Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Speed up query execution. Can we add an index or rewrite the query RE: Speed up query execution. Can we add an index or rewrite the query

  • November 24, 2017 at 11:27 pm

    #1969428

    Quick question, can you run the query with OPTION (MAXDOP 1) and post the actual execution plan? The paralellism is causing lots of noise and my thought is that it's doing more harm than good.
    😎
    Could you also post the DDL (create table & indices) scripts, makes it easier to analyse the query and the execution plan 😉