Measured Database Operations 

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.