Database Administration (MOSC)

MOSC Banner

Partitioned indices - LOCAL or GLOBAL

edited Apr 15, 2013 8:57PM in Database Administration (MOSC) 6 commentsAnswered

Hi

We have a question on partitioned indexes

Assuming that we have a non partitioned table and we are converting that into a partitioned table. During the process, obviously the indices would have
to be partitioned as well.

Assuming that the table was partitioned on a DATE column using RANGE partitioning and there was an index on the table on DATE column prior to partitioning, can someone please explain preferrably with an illustration or example, if, after the partitioning the index should be created as LOCAL or GLOBAL? What is the criteria / guide lines for selecting whether to create the index as LOCAL or GLOBAL

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