Understanding the Benefit from Auto Indexing
Hi
I am playing with the AI feature, and enabled AI as per:
exec dbms_auto_index.configure('AUTO_INDEX_MODE','IMPLEMENT');
Now, I can see a bunch of SYS_AI... indexed being created, and over time I can see that some of the indexes are now visible/usable.
This is all great, but I want to see what impact these new indexes are having on the queries running, and maybe present back to the customer how great this all is, so I create a report for the last 7 days
select dbms_auto_index.report_activity(activity_start => systimestamp-7,activity_end=>systimestamp, type => 'HTML') from dual;