select * from MyTable where Id=123456;
The first time I execute this query it takes 14 seconds. However, the second time I execute it takes 0 seconds.
I wanted to clear the cache so the second execution takes 14 second just like the first execution. So i tried:
DBCC FREESESSIONCACHE; DBCC FREEPROCCACHE; DBCC DROPCLEANBUFFERS; DBCC FREESYSTEMCACHE('ALL'); CHECKPOINT;
But no success. I'm using ms sql server management studio (2005). I also tried the option Reset client statistics. I even restarted the sql server. No matter what I try, it looks like the result keeps somewhere saved.
Does somebody have a solution for this?