2
Answers

query about sql server table query???

Vipin Mittal

Vipin Mittal

7y
186
1
i have a query
 
"select * from tablename"
 
thats taken execution time 10 second first time
but when i execute again then take 2 second
whats the reason ????
Answers (2)
0
Vipin Mittal

Vipin Mittal

NA 699 3.7k 7y
thank u very help full ths article
0
Bryian Tan

Bryian Tan

NA 9.4k 887.3k 7y
This article provide the explanation to it. https://littlekendra.com/2016/11/25/why-is-my-query-faster-the-second-time-it-runs-dear-sql-dba-episode-23/