For Oracle 10g and above: except in cases where a local index cannot be used and a global index is needed (e.g. unique constraint), is there any reason to favor a global index over a local index?
Tell me more
×
Database Administrators Stack Exchange is a question and answer site for
database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
|
There is a point where the queries using the index are accessing enough partitions that a local index will be slower than a global index. For example, if your table is partitioned by date, but you are querying only on a status column. |
|||
|
|