Post reply

Problem with long running query

  • December 21, 2011 at 9:04 am

    #1424310

    If you can post the new plan we can look it over to see if we can improve it further. 5 seconds is still slow in my book 😉

  • December 21, 2011 at 9:27 am

    #1424329

    ok, i will post it but ... tomorrow .. hold on

    and thank you

    Chris

    I want to know all secrets about MS SQL Server :w00t:

  • December 22, 2011 at 5:58 am

    #1424744

    Now here is the actual execution plan from the DEV Server.

    I was wrong, execution is fast as expected

    Thanks again for your kind support

    Chris

    I want to know all secrets about MS SQL Server :w00t:

  • December 22, 2011 at 6:47 am

    #1424773

    What are the indexes on the table Arueck?

    This shouldn't scan!

  • December 27, 2011 at 12:37 am

    #1425590

    Sorry for late reply because of XMas 😉

    Merry XMas to you all

    The index on Arueck is only a clustered index on fr_id, which is needed (i think) for the second part of the query

    Thx

    Chris

    I want to know all secrets about MS SQL Server :w00t:

Viewing 5 posts - 16 through 20 (of 20 total)

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