Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Execution plan Index seek VS Key lookup
Message
De
02/05/2011 22:22:53
Naomi Nosonovsky
Wisconsin, États-Unis
 
 
À
02/05/2011 21:25:46
Michel Fournier
Level Extreme Inc.
Petit-Rocher, Nouveau-Brunswick, Canada
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Indexation
Titre:
Re: Execution plan Index seek VS Key lookup
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01509137
Message ID:
01509141
Vues:
35
>In this execution plan, is it better to see an Index seek or a Key lookup?

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.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform