Bookmark Lookup Question

Last Post 07 Jan 2009 07:17 PM by phsatech. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
phsatech
New Member
New Member

--
06 Jan 2009 05:09 PM
I have a large SQL statement with several joins and there is a bookmark lookup I'm trying to eliminate.
When I use Showplan, in the output column lists a number of columns. In another article it mentioned in an example that the columns mentioned in the Output column when running Showplan should be the ones needed to create a covering index. Is this correct? And




phsatech
New Member
New Member

--
07 Jan 2009 07:17 PM
thnxs for the reply. I may end up passing on adding another index expecially a new one with many keys on a table that has over 7 million rows.
You are not authorized to post a reply.

Acceptable Use Policy