Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Optimisation as per execution plan
Message
De
25/10/2011 10:58:54
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Indexation
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01526170
Message ID:
01527288
Vues:
38
>If the Statistics have not been updated, you may have wrong estimates. Also, did you try comparing original number of IO read operations with the new one? May be it increased dramatically because of newly added records?

Well, now that I am thinking of it, I can simulate that also on the test server. And, on that one, only 10 to 20 records were added. The execution shows the Key lookup at 66% down the Nested loops (inner join). That one shows a 0% cost.
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform