Skip to Content
avatar image
Former Member

Result of the Explain SQL function database-specific ?

Hello, gurus...

I'm not able to find the "secondary index" information in ST05 + Explain.

Is the Explain SQL function database-specific ?

We're running SAP ECC 6.0 on a MSSQL database....

Please advice.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 17, 2008 at 08:59 AM

    Is the Explain SQL function database-specific ?

    yes it is. It must be database specific because it shows what the database is doing.

    But also MSSQL shows you the index information.

    Check the Explain, and search for clustered index seek, behind you will something like

    tablename1, telling you that the first index was used. Primary index is tablename0.

    Siegfried

    Add comment
    10|10000 characters needed characters exceeded