Posted by Jens on 09/16/05 13:38

Do other queries which benefit of indexes also have bad performance ?


Where SD.[Date] > Dateadd(Month,-2,Getdate())

does a row based comparison, not using the indexes or what does the
query plan tells you about it ?

(Markt the query in QA and press CTRL+L) to see it.

Jens Suessmeyer.

[Back to original message]