Posted by Hugo Kornelis on 10/25/07 19:48

On Wed, 24 Oct 2007 22:13:11 -0700, DBMonitor wrote:

>Does anyone know of a reason why there would be such a difference in
>query speed?

Hi DBMonitor,

In addition to the suggestion posted by Roy, have you considered that
this may be caused by cachhing? In other words, if you run the second
query first and the first query last, or if you run both queries
repeatedly, does that change anything to the execution time?

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

[Back to original message]