Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Query processor could not produce a query plan because of the hints defined in this query. RE: Query processor could not produce a query plan because of the hints defined in this query.

  • November 30, 2015 at 3:57 pm

    #1843050

    In more detail, index "FDX_spG_NU_QA_V12" does not contain at least one of the columns:

    MC.col1 / MC.col2 / MC.col3

    If you believe such an index could be helpful enough to this query, you should look at adding (INCLUDEing) the missing column(s) in that index. Then you can re-try the query.

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.