0

I am optimizing my SQL script and when i tried to run it i noticed the following;

  1. Script full query execution (end to end) took more than 2hours to complete
  2. Script query-by-query execution took 44 mins to complete

I'm just wondering, why is my script full query execution took so much runtime than the same script query-by-query execution? Is there some hidden process happening inside the DB? Or any special case for those execution scenario?

Tried to ask our DBA, but he seem to avoid the question maybe he doesn't know. I hope ill got some answers/leads here.

Thanks

Kryle Quimpo
  • 13
  • 5

0 Answers0