DBA > Job Interview Questions > Microsoft SQL Server FAQs

What is a bookmark lookup?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is a bookmark lookup?

Answer
An operation where the row in the heap or clustered index is found from the bookmark in the index.

Explanation
A bookmark ID is stored in an index and points back to the actual row in the heap or clustered index of the table. The lookup operation occurs when an index satisfies a search and the actual row is retrieved from the table.

(Continued on next question...)

Other Job Interview Questions