Hi,
I have stored procedure that use local temp table and drop it at the end of the procedure.
It takes 56 Seconds to execute at the first time. At second time, It takes 16 seconds to execute it again. Then, It takes 6 secs to execute it again.
I wait for 5 mins and execute the same procedure again, it takes 56 seconds again.
Do you have any idea? Why it takes 56s after waiting for 5 mins.
Mya