Home > IT Answers > Database > Improving the initial speed of a SQL query
SQL Server Ask the Experts
2,585 pts.
 Improving the initial speed of a SQL query
SQL queries, SQL Query, SQL query optimization
I have optimized my SQL query to the maximum extent. The first time I ran the query, it took 7 seconds; the next time it took half a second. Why did this happen? How can I make the query run faster the first time around?

Software/Hardware used:
ASKED: July 21, 2009  6:11 PM
UPDATED: July 21, 2009  6:28 PM
RELATED QUESTIONS
Answer Wiki:
I think this is the same question as <a href="http://itknowledgeexchange.techtarget.com/itanswers/sql-server-2005-query-very-slow-in-the-first-run/">this one</a>, which was already answered by Kccrosser.
Last Wiki Answer Submitted:  July 21, 2009  6:21 pm  by  carlosdl   63,580 pts.
All Answer Wiki Contributors:  carlosdl   63,580 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _