Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can this be faster
Message
De
29/10/2015 12:39:43
 
 
À
29/10/2015 04:10:25
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Versions des environnements
SQL Server:
SQL Server 2014
Application:
Desktop
Divers
Thread ID:
01626554
Message ID:
01626633
Vues:
53
>Hi,
>Execution Plan for my query is attached - but Naomi's suggestion runs in 5 secs whereas mine was taking 25 so that's good enough.
>

Yes, Naomi's code hits the "sweet spot" - and (not "but") it's important to understand "why". Take a look at the execution operators now in the new query, and compare it to the old plan. Notice a difference? :)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform