Keyset Showplan Operator

The Keyset operator uses a cursor that can see updates, but not inserts made by others.

Keyset cursor operator iconGraphical execution plan icon

See Also

Tasks

How to: Display an Actual Execution Plan

Reference

Cursor Logical and Physical Showplan Operators

Concepts

Logical and Physical Operators Reference
Keyset-driven Cursors (Database Engine)
Displaying Execution Plans by Using the Showplan SET Options (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance