Cursor Logical and Physical Showplan Operators
Cursor logical and physical operators are used to describe how a query or update involving cursor operations is executed. The physical operators describe the physical implementation algorithm used to process the cursor; for example, using a keyset-driven cursor. Each step in the execution of a cursor involves a physical operator. The logical operators describe a property of the cursor, such as the cursor is read only.
Cursor logical operators include: Asynchronous
The cursor table is populated asynchronously. For more information, see
Asynchronous Population. Optimistic
This cursor uses the optimistic mode of concurrency. For more information, see
Cursor Concurrency. Primary
This is the primary fetch query for this cursor.
This cursor uses read-only semantics for concurrency. This cursor can only read data, not insert, update, or delete it. For more information, see
Cursor Concurrency. Scroll Locks
This cursor uses scroll locks for concurrency. For more information, see
Cursor Concurrency. Secondary
This is the secondary fetch query (used if the primary fetch query fails).
The cursor table is populated synchronously.
Cursor physical operators include: Dynamic
This cursor can see all changes made by others. For more information, see
Dynamic Cursors. Fetch Query
This query retrieves rows when a fetch is issued against a cursor.
This cursor can see updates made by others, but not inserts. For more information, see
Keyset-Driven Cursors. Population Query
This query populates a cursor's work table when the cursor is opened.
This query fetches current data for rows in the cursor fetch buffer.
This cursor does not see changes made by others. For more information, see
For more information about the SQL Server Database Engine cursor models, see
. Cursor Types (Database Engine)