Posted by traceable1 on 04/03/06 18:37

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: Re: float numbers
• Thread view: Testing Query Performance - clear out cache

[Reply to this message]