Join us free for the Data Summit Connect 2021 virtual event!
We have a limited number of free passes for our White Paper readers.
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.