• For the first time, it takes more time bcs of the compiling. For the subsequent runs, it uses the stored plan in the memory.

    After 1 hr if the same thing repeats, most likely it's getting recompiled. Check and see if you are experiencing any memory pressure.

    --

    SQLBuddy