I have sql server 2005 database. When I execute a query for the first time it takes much time to return the result, but subsequent queries execute quicker.
Why is this happening?
Asked
Active
Viewed 739 times
-3
-
Duplicate: http://stackoverflow.com/questions/6611994/my-query-runs-faster-the-second-time-around-how-do-i-stop-that – Andrey Gordeev Feb 20 '13 at 07:09
-
Duplicate http://stackoverflow.com/questions/1873025/how-can-i-clear-the-sql-server-query-cache – Meherzad Feb 20 '13 at 07:11
2 Answers
2
Because sql server stores query execution plan for it when it runs first time ..so in second time and third time it use same query plan which actully save time and return quick resule..
Pranay Rana
- 175,020
- 35
- 237
- 263
0
Because It creates execution plan when you run it first time and second or next time it just verify the execution plan and do not take time to create execution plan. That's why it gives result in quick time.
Sharad
- 743
- 2
- 14
- 23