Database Tuning (MOSC)

MOSC Banner

High number of sub-partitioned table - Global vs Local index

edited Jul 18, 2020 5:04AM in Database Tuning (MOSC) 4 commentsAnswered

Hi,

We have a bunch of huge transaction tables with partition (range on DATE COLUMN) and sub-partition(hash on ID COLUMN). Most of the reads are going through the ID column where we created GLOBAL index. The main partition on DATE column is to split the old records to have low hit on new/latest data. We didn't create any index on DATE column. Now, the question is whether having GLOBAL index on ID column alone is good or bad. What's the recommended approach in this scenario?

Thank you!

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center