Oracle Magazine, July/August 2019
Emerging Technologies AUTONOMOUS Id Operation Name Rows Bytes Cost CPU Time 0 SELECT STATEMENT 1 14 3 0 00 00 01 1 TABLE ACCESS FULL REGIONS 1 14 3 0 00 00 01 Predicate Information identified by operation id PLAN_ TABLE_ OUTPUT ORACLE MAGAZINE JULY AUGUST 2019 122 1 filter REGION_ NAME Europe 13 rows selected John calls the attention of the audience to the output and the fact that the SQL statement did not use the index just created where it could have The reason is simple The index is marked as invisible to the optimizer He then alters the index to make it visible to the optimizer and checks the execution plan of the same SQL statement SQL alter index ix_ region_ id_ 01 visible Index altered SQL explain plan for select from regions where region_ name Europe Explained
You must have JavaScript enabled to view digital editions.