Posted by Erland Sommarskog on 04/10/06 10:27

just.an.imbecile (johntarr@gmail.com) writes:
> I actually got it working. I was using QuickKeys to automate a process
> and found a way around re-running the query. However, for future
> reference, are you saying that if you run a query and then re-run the
> same query shortly therafter then the second time it doesn't have as
> much of an impact on the DB?

I didn't really say that. But the impact on the system may be somewhat
smaller the second time, because all data would likely to be in the cache.

The impact of bouncing the data over a temp table, rather than running
the query twice is likely to have less impact.

Then again, it depends very much on the query. A query than retrieves
a couple of rows using indexes and runs sub-second, is nothing to bother
about. A query that has to scan a 10-million row table is nothing to take
lightly in the production environment.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]