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 on demand webcast, Janis Griffin will discuss all the components of automatic indexes and what they do.
You 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.