Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Execution plan Index seek VS Key lookup
Message
From
02/05/2011 22:26:20
Michel Fournier
Level Extreme Inc.
Petit-Rocher, New Brunswick, Canada
 
General information
Forum:
Microsoft SQL Server
Category:
Indexing
Title:
Re: Execution plan Index seek VS Key lookup
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01509137
Message ID:
01509142
Views:
27
>Index seek is better than Key Lookup. You may find articles by Craig Freedman really helpful.
>
>http://sqlblog.com/blogs/denis_gobo/archive/2008/05/23/6953.aspx
>
>Links to Craig's blog
>
>http://blogs.msdn.com/b/craigfr/
>
>I read the series of different kind of joins, but I think any article by him you read can teach a lot.

Thanks, so basically, if the execution plan says Index seek at 4% and Key lookup at 92%, I would have to see what could be done to enhance the query.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform