Posted by Tom Moreau on 04/03/06 18:46

Try:

DBCC FREEPROCCACHE
DBCC DROPCLEANBUFFERS

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
..
"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 -

• Next in forum: Re: Testing Query Performance - clear out cache
• Prev in forum: Testing Query Performance - clear out cache
• Thread view: Re: Testing Query Performance - clear out cache

[Reply to this message]