Entering content frameProcedure documentation The Explain SQL Function Locate the document in its SAP Library structure

The Explain SQL function allows you to analyze the database strategy used to access any given table or view defined in the ABAP Dictionary or in the database itself. With it, you can see the indexes that the system uses.

There are two ways of analyzing an SQL statement:

Note

Note that the result of the Explain SQL function (both the SQL statement and the operation) is database-specific. There are certain database systems under which you can only use the Explain SQL function for the SELECT statement.

To be able to interpret the results of the Explain SQL function, you will need a sound knowledge of the relevant database system. For further information, refer to the documentation of the database manufacturer.

Analyzing an SQL Statement Without a Trace File

  1. On the initial screen of the Performance Trace, choose Explain one SQL statement (for Oracle), or Explain one SQL request (for Informix).
    The system displays a screen containing an input field. Enter the name of the table (or view) that you want to use.
  2. Enter an SQL statement.
    Make sure that you enter the name in uppercase.

    This graphic is explained in the accompanying text
  3. Choose Save.

The system analyzes the statement and displays information about the access strategy of the database.

 

This graphic is explained in the accompanying text

Leaving content frame