Skip to Main Content
Automatic Indexing for Oracle Autonomous Database

About This Workshop

Youtube Video

About This Workshop
Creating indexes requires a deep knowledge of the data model, how client applications behave, and the characteristics of the data stored in the database. In the past, DBAs were responsible for making choices about which indexes to create, and the decisions made were never reconsidered, even if the database changed. As a result, opportunities for improvement were lost, and the use of unnecessary indexes could become a performance liability. Now, Oracle’s Autonomous Database can manage indexes without the need for manual intervention.

Workshop Info

1 hour
  • Provision an Autonomous Database Instance
  • Create an Application Schema and Prepare for Auto Indexing
  • Execute an Application Workload
  • View Athe Auto Index Report
  • View Automatic Indexing Details
  • Sample - Familiarity with Database is desirable, but not required
  • Some understanding of cloud and database terms is helpful
  • Familiarity with Oracle Cloud Infrastructure (OCI) is helpful

Other Workshops you might like