SQL Server

United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

SQL Server

SQL Server 2008 R2

Product Documentation

SQL Server 2008 R2 Books Online

Database Engine

Operations

Performance (Database Engine)

Query Performance

Query Tuning

Analyzing a Query

Logical and Physical Operators Reference

Aggregate Showplan Operator

Arithmetic Expression Showplan Operator

Assert Showplan Operator

Assign Showplan Operator

Async Concat Showplan Operator

Bitmap Showplan Operator

Bitmap Create Showplan Operator

Bookmark Lookup Showplan Operator

Branch Repartition Showplan Operator

Broadcast Showplan Operator

Cache Showplan Operator

Clustered Index Delete Showplan Operator

Clustered Index Insert Showplan Operator

Clustered Index Merge Showplan Operator

Clustered Index Scan Showplan Operator

Clustered Index Seek Showplan Operator

Clustered Index Update Showplan Operator

Collapse Showplan Operator

Compute Scalar Showplan Operator

Concatenation Showplan Operator

Constant Scan Showplan Operator

Convert Showplan Operator

Cross Join Showplan Operator

Cursor Catchall Showplan Operator

Cursor Logical and Physical Showplan Operators

Declare Showplan Operator

Delete Showplan Operator

Deleted Scan Showplan Operator

Distinct Showplan Operator

Distinct Sort Showplan Operator

Distribute Streams Showplan Operator

Dynamic Showplan Operator

Eager Spool Showplan Operator

Fetch Query Showplan Operator

Filter Showplan Operator

Flow Distinct Showplan Operator

Full Outer Join Showplan Operator

Gather Streams Showplan Operator

Hash Match Showplan Operator

Hash Match Root Showplan Operator

Hash Match Team Showplan Operator

If Showplan Operator

Inner Join Showplan Operator

Insert Showplan Operator

Inserted Scan Showplan Operator

Intrinsic Showplan Operator

Iterator Catchall Showplan Operator

Key Lookup Showplan Operator

Keyset Showplan Operator

Language Element Catchall Showplan Operator

Lazy Spool Showplan Operator

Left Anti Semi Join Showplan Operator

Left Outer Join Showplan Operator

Left Semi Join Showplan Operator

Log Row Scan Showplan Operator

Merge Interval Showplan Operator

Merge Join Showplan Operator

Nested Loops Showplan Operator

Nonclustered Index Delete Showplan Operator

Nonclustered Index Insert Showplan Operator

Nonclustered Index Scan Showplan Operator

Nonclustered Index Seek Showplan Operator

Nonclustered Index Spool Showplan Operator

Nonclustered Index Update Showplan Operator

Online Index Insert Showplan Operator

Parallelism Showplan Operator

Parameter Table Scan Showplan Operator

Partial Aggregate Showplan Operator

Population Query Showplan Operator

Refresh Query Showplan Operator

Remote Delete Showplan Operator

Remote Index Seek Showplan Operator

Remote Index Scan Showplan Operator

Remote Insert Showplan Operator

Remote Query Showplan Operator

Remote Scan Showplan Operator

Remote Update Showplan Operator

Repartition Streams Showplan Operator

Result Showplan Operator

RID Lookup Showplan Operator

Right Anti Semi Join Showplan Operator

Right Outer Join Showplan Operator

Right Semi Join Showplan Operator

Row Count Spool Showplan Operator

Segment Showplan Operator

Segment Repartition Showplan Operator

Sequence Showplan Operator

Sequence Project Showplan Operator

Snapshot Showplan Operator

Sort Showplan Operator

Split Showplan Operator

Spool Showplan Operator

Stream Aggregate Showplan Operator

Switch Showplan Operator

Table Delete Showplan Operator

Table Insert Showplan Operator

Table Merge Showplan Operator

Table Scan Showplan Operator

Table Spool Showplan Operator

Table Update Showplan Operator

Table-Valued Function Showplan Operator

Top Showplan Operator

Top N Sort Showplan Operator

UDX Showplan Operator

Union Showplan Operator

Update Showplan Operator

While Showplan Operator

Minimize

This topic has not yet been rated - Rate this topic

Bookmark Lookup Showplan Operator

SQL Server 2008 R2

The Bookmark Lookup operator uses a bookmark (row ID or clustering key) to look up the corresponding row in the table or clustered index. The Argument column contains the bookmark label used to look up the row in the table or clustered index. The Argument column also contains the name of the table or clustered index in which the row is looked up. If the WITH PREFETCH clause appears in the Argument column, the query processor has determined that it is optimal to use asynchronous prefetching (read-ahead) when looking up bookmarks in the table or clustered index.

Bookmark Lookup is not used in SQL Server 2008. Instead, Clustered Index Seek and RID Lookup provide bookmark lookup functionality. The Key Lookup operator also provides this functionality.

Bookmark lookup operator icon Graphical execution plan icon

Tasks

How to: Display an Actual Execution Plan

Reference

Clustered Index Seek Showplan Operator

RID Lookup Showplan Operator

Key Lookup Showplan Operator

Concepts

Logical and Physical Operators Reference

Displaying Execution Plans by Using the Showplan SET Options (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.