Oracle Magazine, July/August 2019
Emerging Technologies AUTONOMOUS SETUP Connected to Oracle Database 19c John starts his demo by executing this SQL statement to enable Automatic Indexing begin dbms_ auto_ index configure AUTO_ INDEX_ MODE IMPLEMENT end Betty is a bit queasy about running a statement like this one that implements automatic indexing in the database without her knowing it Thats understandable John agrees John runs another SQL statement to prepare the database for the feature but he specifies that SQL statements not use the new autocreated indexes ORACLE MAGAZINE JULY AUGUST 2019 120 begin dbms_ auto_ index configure AUTO_ INDEX_ MODE REPORT ONLY end This sets in motion the process of identifying the possible indexes Automatic Indexing John explains captures the SQL statements identifies those from the list that may be helped by indexing and then creates those indexes automatically These autocreated indexes are named with the prefix SYS_ AI to differentiate them from the manually created indexes A new column named AUTO in the DBA_ INDEXES view shows a YES value for these indexes
You must have JavaScript enabled to view digital editions.