Director & Principal Consultant
Richard Foote Consulting
One the most impressive and exciting database innovations introduced in Oracle Database 19c is "Automatic Indexing", an expert system built into the database engine that not only recommends potential new indexes to create, but will actually introduce new indexes in a safe and automated manner. This session explores in-depth this ground breaking feature, detailing how Automatic Indexing works, how it can be deployed and highlights a number of improvements and new capabilities that have been introduced since Automatic Indexing was first released. Attendees will gain an excellent appreciation of the power to Automatic Indexing and how this feature can substantially assist in reducing the risk of having an sub-optimal indexing strategy that causes performance implications.