Mr_Shaw
asked on
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi rrjegan17,
I have added all the select columns into my covering index and it still uses the single column clustered index.
I have added all the select columns into my covering index and it still uses the single column clustered index.
ASKER
thanks
ASKER