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 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
The system analyzes the statement and displays information about the access strategy of the database.