• 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!