• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 322
  • Last Modified:

Bookmark lookup

My clustered index only has one column.

I have bookmark lookup which searching for more columns.

I have added a covering index to removes the lookup, but it has not gone away.

Can anybody help.
0
Mr_Shaw
Asked:
Mr_Shaw
  • 3
  • 2
  • 2
4 Solutions
 
Aaron ShiloCommented:
hi

read this to understand more about this issue.

http://blogs.msdn.com/b/craigfr/archive/2006/06/30/652639.aspx
0
 
Mr_ShawAuthor Commented:
I used a index hint and it uses the lookup has gone.
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
>> I have added a covering index to removes the lookup,

Seems like you have missed adding columns in your SELECT clause to avoid Bookmark Lookup
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Aaron ShiloCommented:

Caution

Because the SQL Server query optimizer typically selects the best execution plan for a query, we recommend that <join_hint>, <query_hint>, and <table_hint> be used only as a last resort by experienced developers and database administrators.
 
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
>> Seems like you have missed adding columns in your SELECT clause to avoid Bookmark Lookup

Typo..
What I meant is that you have missed columns in SELECT clause of your query in your Covered index.
Covering those columns will help avoid Bookmark Lookup

And as mentioned above, consider using hints as the last option.
0
 
Mr_ShawAuthor Commented:
Hi rrjegan17,

I have added all the select columns into my covering index and it still uses the single column clustered index.
0
 
Mr_ShawAuthor Commented:
thanks
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now