Post reply

Using show actual execution plan causes increased execution time

  • August 1, 2011 at 2:37 pm

    #1361846

    Glad this is getting better.

    Want to post the actual execution plan so we can get this under 1 sec? 8 sec for so little data seems really slow to me.

  • August 1, 2011 at 3:09 pm

    #1361868

    GilaMonster (8/1/2011)

    No its not, but SQL still has to track the run-time information through each one. The plans for the functions are still generated, they don't get returned for management studio, but they're still all generated (and you can see them with the profiler actual execution plan event, which is Statistics XML)

    Yes, that is it. I found all the plans generated for the function call with SQL Profiler. 🙂

    Thank you very much for all your help.

  • August 1, 2011 at 5:14 pm

    #1361899

    John H Davis (8/1/2011)

    GilaMonster (8/1/2011)

    No its not, but SQL still has to track the run-time information through each one. The plans for the functions are still generated, they don't get returned for management studio, but they're still all generated (and you can see them with the profiler actual execution plan event, which is Statistics XML)

    Yes, that is it. I found all the plans generated for the function call with SQL Profiler. 🙂

    Thank you very much for all your help.

    So getting this down under 1 sec is under no interest?

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply