Oracle Magazine, July/August 2019
Emerging Technologies AUTONOMOUS Wait a minute interrupts Betty It simply creates an index without checking in a representational test system whether the index will actually help or hurt something else That sounds like an incredibly stupid idea especially for a machine Not quite assures John Creating an index on a whim is not smart Therefore the Automatic Indexing feature creates the index as invisible it is not known to the database optimizer He explains the concept of an invisible index to the audience with a simple demonstration He creates an index but with the invisible keyword SQL create index ix_ region_ id_ 01 on regions region_ name invisible ORACLE MAGAZINE JULY AUGUST 2019 121 Index created Then he checks the plan of a very simple SQL statement against that table SQL explain plan for 2 select from regions where region_ name Europe Explained SQL select from table dbms_ xplan display PLAN_ TABLE_ OUTPUT Plan hash value 3077898360
You must have JavaScript enabled to view digital editions.