- symptom: ORA-14039: partitioning columns must form a subset of key columns of a UNIQUE index
- cause: Local indexes can only be unique if the partitioning key is the part of the index key.
xb.sql and xbi.sql - Explain Oracle Execution Plans Better! (Part 3 -
Cardinality Misestimates)
-
Here’s part 3 of my xb.sql & xbi.sql article series that I started writing
back in 2019 :-) Part 1 - Show and format execution plans by querying
V$SQL_PLAN...
Acum 2 zile
Niciun comentariu:
Trimiteți un comentariu