Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can this be faster
Message
From
29/10/2015 12:39:43
 
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2014
Application:
Desktop
Miscellaneous
Thread ID:
01626554
Message ID:
01626633
Views:
54
>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? :)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform