Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Making use of dates in index
Message
De
03/05/2011 10:11:26
 
 
À
03/05/2011 09:37:09
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Indexation
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01509138
Message ID:
01509212
Vues:
26
>>Chances of formulating 3 as "between" without too much recalc for border value exclusion ?
>
>I already tried to stay away from the between usage. Have you seen a better performance when using it?

Yes, but only once in a big way and that was last century.
There is no reason for optimizers not to pick the best way for both ways to formulate,
but OTOH I've been bitten by assuming too much intelligence baked into the products I use ;-)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform