You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Oracle 19c Auto Indexing (AI) html Reports

Question
10
Views
0
Comments
edited Apr 9, 2020 8:06AM in Oracle Analytics

Summary

How do I interpret 'Original Plan' and 'Plan with Auto Indexes' in the AI html reports?

Content

Hi,

I've enabled Auto Indexing (AI) on our Autonomous Data Warehouse (in Oracle19c).

The first report I ran for the past 24 hours is very self explainatory and it clearly shows the improvements for, before enabling AI (Original Plan) vs after enabling AI (Plan with Auto Indexes). Attached here (report1).

Now that, AI is running in the background, every day I've been collecting this report (for the past 2 days). In these reports, does anyone know how to interpret, Original Plan vs Plan with Auto Indexes (attached - report2 and report3). Here, the

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!