Database DataWarehousing (MOSC)

MOSC Banner

Do we need an index on partition key in partition table ?

edited Sep 28, 2011 1:32AM in Database DataWarehousing (MOSC) 1 commentAnswered
Hi,
In our DWH environment, we need few partitioned tables based upon the date columns and tuning advisor is recommending to create an index on the partitioned key ?
Is it recommended to have index( global or local ) in partitioned table ?


BR,
Anurag 

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