During the execution time no other process is running.
Only the application with this statement is running.
i checked more than 50 times each time i see there is less time in Q1 and more time in Q2
Q1 almost <200 millisecond and Q2 almost ~1800 millisecond every time
that is what my question too why Q2 is taking more time.
When i ran the same query in SSMS it is taking ~1800 millisecond
Q2 and SSMS are having same time then how Q1 alone with less time :w00t:
But both Q1 and Q2 query are from profiler only.
Thanks!