Database DataWarehousing (MOSC)

MOSC Banner

Global/local or normal indexes on partitioned table?

edited Jul 13, 2013 4:17PM in Database DataWarehousing (MOSC) 8 commentsAnswered

11.2.0.2

Hi,

When creating indexes on a partitioned table (range), should I only create a global/local index on the partitioned column or should all indexes be created as global or local?

Any hint is welcomed! :-)

Regards

S

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