Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sum on Union
Message
 
 
To
05/02/2013 12:32:18
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01565061
Message ID:
01565190
Views:
35
>>Put the FROM Menu INNER ... or not put it is the same on the execute plan
>>
>>The true difference is on FULL JOIN instead the UNION.
>
>Ah, I didn't pay attention to the FULL JOIN at first. So, basically, it is just a choice on how we write this SQL command.

In SQL Server you want to test proposed solutions as you don't know in advance (unless it's obvious) which solution will perform better.

The simplest (although not necessary accurate) way to test is to put both statements in 1 batch and run with execution plan on and then see percentage difference.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform