Oracle Magazine, July/August 2019
Emerging Technologies AUTONOMOUS ORACLE MAGAZINE JULY AUGUST 2019 124 Index altered SQL explain plan for select from regions where region_ name Europe Explained SQL select from table dbms_ xplan display Plan hash value 3077898360 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 Pointing to the output John shows that the index is not used now even though its visible He confirms that by using the following SQL SQL select VISIBILITY STATUS from user_ indexes where index_ name IX_ REGION_ ID_ 01 VISIBILITY STATUS VISIBLE UNUSABLE
You must have JavaScript enabled to view digital editions.