Problem with long running query

  • 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 😉

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

    and thank you

    Chris

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

  • 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:

  • What are the indexes on the table Arueck?

    This shouldn't scan!

  • 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