I used SET STATISTICS TIME ON to find the execution time of a set of SQL queries. Each time i execute the query, i get a different execution time.
I cleared Cache before each execution. But still i don't get a consistent Execution time. The first time i executed the query and got 39ms as the total execution time. But the next time i executed the same set of queries i got 486ms as execution time. i'm not sure if i'm interpreting it in the wrong way.
What should i do?
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)