Answer
Bookmark lookup occurs when SQL uses a non-clustered index but must fetch extra columns from the base table.
This becomes slow when many rows match, increasing I/O and reducing performance.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ