Information générale
Forum:
Microsoft SQL Server
Versions des environnements
SQL Server:
SQL Server 2012
>>>>>Indexes are based upon statistics. If the index is not there, the statistic is missing. Apparently adding the index lets the optimizer conclude not to use the index because the cost is too high. It could not draw that conclusion without the index because then the statistics were missing
>>>>
>>>>So the optimizer wants the index so it knows it doesn't want the index.
>>>>
>>>>There is something witty here to say about MSSQL being either like a cat or a woman... I can't decide.
>>>
>>>Hmmm ... I wonder if I should be offended by that? < g >
>>
>>I doubt you are easily offended. Boston ladies, they are TOUGH. Even if they do migrate to the easy coast.
>>
>>Speaking of Boston ladies, I have two words for you: Dennis Levine. He is as good a writer as we have going. Men will never completely figure out women but he sure seems to have some insight.
>
>You're right, I'm NOT easily offended. But, where did you get the idea I was from Boston? I'm from Connecticut.
>
>I've not heard of Dennis Levine, I'll look him up ... are you sure you don't mean Dennis Lehane? I've read his stuff.
Dennis Lehane, you're right.
As far as Boston vs. Connecticut, they're both in New England so same diff ;-)
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement