Database DataWarehousing (MOSC)

MOSC Banner

Global Indexes verses Local Indexes!

edited Feb 10, 2013 8:04PM in Database DataWarehousing (MOSC) 4 commentsAnswered
Just a quick question really.
I have a table (TableA) with a Primary Key (PK).  I have to range partition Table A using a column (CreateDate).  As you will know this now means I cannot create the unique index for PK as a LOCAL index and I therefore have to create this as a GLOBAL index.  I do not want to be left exposed to indexes becoming unusable and bringing down the system therefore I wanted to check if my suggested solution is correct .........

my proposal would be to sub-partition by PK, would this then mean that I could make the unique index (PK) a local index and I would be free to delete records from TableA without worrying about indexes becoming unusable?

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