Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sum on Union
Message
 
 
À
05/02/2013 12:32:18
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01565061
Message ID:
01565190
Vues:
34
>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform