My Oracle Support Banner

Automatic Indexing - Autonomous Database (Shared) (Doc ID 2764331.1)

Last updated on MAY 12, 2021

Applies to:

Autonomous Database on Shared Infrastructure - Version N/A to N/A
Information in this document applies to any platform.


The automatic indexing feature in Oracle Database is enabled in Autonomous Database. The automatic indexing feature automates index management tasks, such as creating, rebuilding, and dropping indexes in an Oracle Database based on changes in the application workload.

This feature improves database performance by managing indexes automatically in an Oracle Database.  This Note explains how to enable / disable Auto Index functionality at Database / Schema / Table level.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.