Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » Context-Sensitive Help » SQL Anywhere plug-in help » Introduction to SQL Anywhere properties windows


SQL Statement Details window

The SQL Statement Details window has a SQL Statement Details pane and a Query Information pane. Note that the fields displayed vary with the SQL statement selected, so you may not see all the fields that are described below.

SQL statement details   The following information is provided for the SQL statement:

  • Request ID   Shows the request ID.

  • SQL statement   Shows the full text of the selected SQL statement. Note that the text displayed for the statement may not match the original text. If this statement was captured after it was parsed by the database server (either because it is part of a compiled database object, such as a stored procedure or trigger, or because it was only selected for inclusion in the trace because it satisfied a sampling or cost condition), it may appear different than it was originally written. In particular, queries over views may appear drastically different, since the view definitions are often flattened into the queries (expanded inline).

  • Host/internal variables   Shows host variables, internal variables, and their values for the selected SQL statement.

  • Start time   Shows the statement start time.

  • Duration   Shows the duration of the statement, which is the time the database server spent actually processing the request.

  • Cursor close time   Shows the cursor close time.

  • Connection ID   Shows the connection ID for the selected statement.

  • User   Shows the user ID for the selected statement.

  • SQL error code   Shows the numerical SQL error code associated with the error.

  • Procedure/Trigger   Shows the stored procedure or trigger related to the selected statement.

  • Procedure/Trigger line number   Shows the line number of the applicable procedure or trigger.

Query information   The following query information is provided for the SQL statement:

  • Isolation level   Shows the isolation level for the selected statement.

  • Forward fetches   Shows the number of forward fetches for the selected statement.

  • Reverse fetches   Shows the number of reverse fetches for the statement.

  • Absolute fetches   Shows the number of absolute fetches for the statement.

  • First fetch time   Shows the first fetch time for the selected database.

  • Used optimizer bypass   Shows whether the optimizer bypass was used.

  • Actual text plan   Shows the actual text plan.

  • Plan at execution time   Shows the plan at execution time. Click an objects to display the details for that object. Click Advanced Details to display more details.

See also