Viewing 3 posts - 1 through 4 (of 4 total)
The Column is of type DateTime
I looked at the execution plan and when I was using the variable it was using the clustered indexes but when I was using a...
October 26, 2006 at 8:07 am
#668194
Ah now I see the light, I looked at the estimated execution plan and the CPU IO cost was a lot higher for the statement with the variable.
October 25, 2006 at 12:45 pm
#667971
I have no idea what you mean by freeing the cache..
October 25, 2006 at 12:33 pm
#667967