-
EST
Online
Oracle 19c brings us a very powerful new feature for index management called 'Automatic Indexes'. Automatic indexing requires very little effort from a DBA as it automates the creation, tests the validity and performance of indexes, removes obsolete or redundant ones, and continuously monitors their usage.
In this presentation, Janis Griffin will discuss all the components of automatic indexes and what they do. The attendee will further learn how to enable/disable automatic indexing, control it at the schema-level, and see several examples of automatic indexes in action. Finally, several system views and the activity report will be shown.
Speaker: Janis Griffin
