sqloracle-databaseindexingoracle-sqldeveloper

How to determine if and which index is being used in oracle

Could anyone provide instructions on how will I check or verify if the index I created is being used in the query? Thank you.

Solution

  • 1. EXPLAIN PLAN FOR

    Use the EXPLAIN PLAN statement to generate an execution plan for the query:

    EXPLAIN PLAN FOR
your_query_here

    2. Retrieve the Execution Plan

    After generating the execution plan, you can retrieve it with the DMBS_XPLAN package:

    SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY);

    Read this: