Skip to Content

index advisor

hi,

can anyone please tell me how a secondary index can be deemed as effective?

i did trace for a user and the EXPLAIN shows:

Now after running index advisor and doing another EXPLAIN including the recommended secondary index, the new EXPLAIN shows:

Since the "Estimated Costs" (high-lighted in yellow) did not actually improve, this means that the recommended secondary index is not effective. Is my assumption correct? If not, how do I know if a secondary index is effective?

Thank you.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 12, 2015 at 09:18 PM

    Hi Caldoza

    You can enable the transaction code ST12 trace on any transaction or Z reports, check the Sql trace seconder index used or not.

    BR

    SS

    Add comment
    10|10000 characters needed characters exceeded

    • S Sriram Kristofferson Caldoza

      Hi

      On your Development system enable the trace before creating the seconder index and then create the seconder index enable the ST12 trace, analysis the both traces and take the action.

      BR

      SS