Database Administration (MOSC)

MOSC Banner

local prefix index vs global partition index

edited Jul 27, 2019 5:06AM in Database Administration (MOSC) 3 commentsAnswered

I am planning to partition the PAY_RUN_RESULTS in EBS 12.1.3 with Hash partition and RUN_RESULT_ID column is going to be partition key and also primary key column in the table.

My question is what difference it makes if i create local prefix index on partition key column (RUN_RESULT_ID) or create global partition index with same number of partition as table on RUN_RESULT_ID column?

Both method are going to create same number of partitions. Does this means local index partition and table partition has same data but global index partition is not similar to table partition?

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