Each SQL statement is broken down into database operations by the R/3 System. The SQL Trace allows you to measure the runtime of each of these operations:
DECLARE |
Defines a new cursor within an SAP work process and assigns the SQL statement to it. The short form of the statement is displayed in the list of trace records. The cursor has a unique cursor ID, which is used in communication between the R/3 System and the database system. |
PREPARE |
Converts the SQL statement and determines the execution plan. |
OPEN |
Opens a cursor for a prepared (converted) SELECT statement. OPEN passes the parameters for the database access. It is only used with SELECT statements. |
FETCH |
Passes one or more records selected in the SELECT statement to the database interface of the R/3 System. The data records are identified by the cursor ID. |
REOPEN |
Reopens a cursor prepared by the system for a previous SELECT statement and passes a new set of parameters to the database. |
EXEC |
Passes the parameters for the database statement, and executes the statements that change data in the database (such as UPDATE, DELETE, or INSERT). |
REEXEC |
Reopens a cursor prepared by the system for a previous EXEC statement. |
For information about the sequence in which these operations occur, refer to
Logical Sequence of Database Operations.