|
Posted by Jack Vamvas on 04/03/06 18:49
Use" dbcc freeproccache" to clear the proc cache
--
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
"traceable1" <tracykc@gmail.com> wrote in message
news:1144078630.796134.94070@t31g2000cwb.googlegroups.com...
>
> I am trying to improve the performance of a query. No matter how bad
> it runs the first time, it runs really fast the second time.
>
> So how can I tell if I've done anything to improve the query if it
> always comes back quickly after the first run? I assume the
> query/data/plan is in cache - how can I clean it out for my session?
>
> Thanks in advance for any help you can provide -
>
Navigation:
[Reply to this message]
|