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