Oracle Magazine, July/August 2019
Emerging Technologies AUTONOMOUS If the recommended index will affect the data manipulation language DML SQL statements negatively If the indexes created earlier once useful are still useful If a fresh analysis of the need for new indexes is required due to data and structural ORACLE MAGAZINE JULY AUGUST 2019 119 changes The last part is particularly tricky John points out The table and columns and even the SQL statements may not have changed but if the data pattern has changed the once useful indexes may not be useful anymore while also being a drag on the performance of DML statements Similarly some indexes not needed earlier could actually help after data pattern changes And because data pattern changes are almost impossible to track down the battle for the ideal indexes is usually a losing one AUTOINDEXING COMES TO THE RESCUE This is where a new feature in Oracle Database 19c Automatic Indexing comes to the rescue continues John The feature acts like a DBA inside the database that evaluates the need for new indexes and the need for the existing indexes creates new ones if theyre needed and drops them when they are no longer needed Both single column and concatenated indexes are considered by the feature so it covers a majority of the indexes typically used in a database But the best part John reminds everyone is that its software It works 24 hours a day seven days a week and does not get tired does not take sick leave and does not ask for raises It will do everything Tanya is asking for Everyone is listening
You must have JavaScript enabled to view digital editions.