Oracle Magazine, July/August 2019
Emerging Technologies AUTONOMOUS BY ARUP NANDA Autonomous Indexing The new Automatic Indexing feature in Oracle Database 19c detects the need for indexes creates them and drops them automatically without DBA intervention John the chief architect of Acme Travels walks into the office of the CTO Tanya and he can almost smell the frostiness in the air Acme a travel products company has been operating for more than 20 years and during that time the companys data model has evolved as any 20 year old companys data model would The developers create new tables alter the existing tables write new SQL statements and modify the existing SQL constantly To improve performance they create indexes on the columns proactively but more often they add indexes later after a performance issue has been detected The DBA manager Betty points out that adding indexes to address performance issues is a double edged sword It may improve performance for some queries but it will definitely slow down INSERT statements and may negatively impact ORACLE MAGAZINE JULY AUGUST 2019 116 ORACLE DATABASE
You must have JavaScript enabled to view digital editions.