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.

• Next in forum: Re: Extremely Slow Table
• Prev in forum: Extremely Slow Table
• Thread view: Re: Extremely Slow Table

[Reply to this message]