SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Index On Partition Key Column - What will be the benefit

zzzzzzzJan 29 2018 — edited Jan 29 2018

Hi All,

Please excuse me if my question is silly and very generic - I tried searching, but could not get a proper result.

In the environment I am working on, I can see most of the partitioned tables are having a LOCAL index created on the partition-key column . Eg: f_payment is a daily partitioned table on payment_date column - And there is a LOCAL index defined on payment_date.

What could be the benefit of this index ?

Thanks in advance

This post has been answered by Jonathan Lewis on Jan 29 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 26 2018

Added on Jan 29 2018

6 comments

2,646 views