Page tree
Skip to end of metadata
Go to start of metadata
Showplan Messages (6200s)

No new writeups yet

6201      10               STEP %d
6202      10                   The type of query is SELECT (into Worktable%d).
6203      10                   The type of query is %s.
6204      10           %s  The update mode is direct.
6205      10           %s  The update mode is deferred.
6206      10           %s  GROUP BY
6207      10                   Vector Aggregate
6208      10           Scalar Aggregate
6209      10           %s  This step involves sorting.
6210      10                   Worktable%d created, in %s locking mode, for ORDER BY.
6211      10                   Worktable%d created, in %s locking mode, for DISTINCT.
6212      10           %s  Worktable%d created, in %s locking mode, for REFORMATTING.
6213      10                   Worktable%d created for SELECT_INTO.
6214      10           %s  TO TABLE
6215      10           %s  FROM TABLE
6216      10           %s  Worktable%d.
6217      10           %s  %.*s
6218      10                   DISJOINT TABLE : nested iteration.
6219      10                   Nested iteration.
6220      10                   EXISTS TABLE : nested iteration.
6221      10                   Using GETSORTED
6222      10           %s  Using Dynamic Index.
6223      10           %s  Table Scan.
6224      10           %s  Using Clustered Index.
6225      10           %s  Index : %.*s
6226      10           %s  Index name not found.
6227      10           %s  Log Scan.
6228      10           Cursor name '%.*s' is declared on procedure '%.*s'.
6229      10           Cursor name '%.*s' is declared at nesting level '%d'.
6230      10           The cursor is positioned after the last row.
6231      10           The current cursor position has been deleted.
6232      10           The cursor is positioned before the next row.
6233      10           The cursor is positioned on a row.
6234      10           There have been %d rows read, %d rows updated and %d rows deleted through this cursor.
6235      10           The cursor is not open.
6236      10           The cursor will be closed if the current position is deleted.
6237      10           The cursor will be closed when a transaction is committed or rolled back.
6238      10           The cursor will remain open when a transaction is committed or rolled back.
6239      10           The number of rows returned for each FETCH is %d.
6240      10           The cursor is read only.
6241      10           The cursor is updatable.
6242      10           There are %d columns returned by this cursor.
6243      10           The result columns are:
6245      10           Name = '%.*s', 'Expression Result', Type = %s, Length = %d (%S_MSG)
6246      10           Name = '%.*s', Table = '%.*s', Type = %s, Length = %d (%S_MSG)
6247      10           The cursor was opened with these parameters:
6248      10           %s
6249      10           There are no active cursors.
6250      10           There are no active cursors that match the search criteria.
6251      10           This cursor is declared within a stored procedure. The cursor's memory usage cannot be distinguished from that of the procedure as a whole.
6252      10           This cursor is declared on a stored procedure. It is presently using '%d' bytes. However, the memory usage will increase when the cursor is opened because the query plan will be associated with the cursor at that time.
6253      10           This cursor is declared on a stored procedure. It is using %d bytes of memory. The procedure's plan (%d bytes) will be returned to the procedure cache when the cursor is closed.
6254      10           This cursor is using %d bytes of memory.
6255      10           The cursor id is %d.
6256      10           The cursor has been successfully opened %d times.
6257      10           The cursor was closed by a CLOSE CURSOR statement.
6259      10           The cursor was closed because its current scan position could not be maintained following a delete, update or insert.
6260      10           The cursor was closed because it was declared on a join and its current position was deleted.
6261      10           The cursor was closed due to an error on the OPEN CURSOR statement.
6262      10           The cursor was closed because CLOSE ON ENDTRAN was SET ON and the transaction containing the cursor ended.
6263      10           The cursor is read only because it is declared on a union.
6264      10           The cursor is read only because it is declared on a group by or its plan includes a group by operation.
6265      10           The cursor is read only because it contains a DISTINCT.
6266      10           The cursor is read only because it contains an aggregate.
6267      10           The cursor is read only because it contains an ORDER BY clause.
6268      10           Showplan output for the cursor:
6269      10           The cursor is currently scanning at isolation level 0.
6270      10           The cursor is currently scanning at a nonzero isolation level.
6271      10           The cursor was compiled at isolation level %d.
6272      10           %s  Using I/O Size %d Kbytes for index leaf pages.
6273      10           %s  With %S_MSG Buffer Replacement Strategy for index leaf pages.
6274      10           %s  Evaluate Grouped %s.
6275      10           %s  Evaluate Ungrouped %s.
6276      10           %s  Forward Scan.
6277      10           %s  Backward scan.
6278      10           %s  Positioning at start of table.
6279      10           %s  Positioning at end of table.
6280      10           %s  Positioning by Row IDentifier (RID).
6281      10           %s  Positioning by key.
6282      10           %s  Positioning at index start.
6283      10           %s  Positioning at index end.
6284      10           %s  Scanning only the last page of the table.
6285      10           %s  Scanning only up to the first qualifying row.
6286      10           %s  Index contains all needed columns. Base table will not be read.
6287      10           %s  Keys are:
6288      10           %s    %.*s %S_MSG
6289      10           QUERY PLAN FOR STATEMENT %d (at line %d).
6290      10           MRU
6291      10           LRU
6292      10                   Using %d Matching Index Scans

  • No labels