Hello Folks;
I was wondering how to obtain execution plan without the use of a specific list of indexes ?
Usually I use : "explain plan for <SQLquery>; select * from table(dbms_xplan.display);" or "set autotrace on" if i'm allowed to execute the query.
But before dropping an index (a list of indexes) it will be great to have the 2 executions plan (before and after drop index).
I was thinking...if you have a query to know in which SQLIDs a list of indexes is in use it will be helpfull to.
Thanks for your help, regards
Antoine