none
How to overcome the error "The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions.". RRS feed

  • Question

  • After executing the query below the error has appeared "The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer Support Services for more information." . How can i solve this issue. If any options is there to specify the maximum size of string in a query. The query is given below.

     

    *,SELECT COCLV.OBJECT_ID,CLM.LOV_ID,CLM.CHAR_ID,COCLV.OBJECT_REV_NO, CLM.LOV_VALUE, CLM.LOV_DESCRIPTION FROM CUSTOM_LOV_MSTR  CLM  LEFT OUTER JOIN CUSTOM_OBJECT_CHAR_LOV_VALUES COCLV on  COCLV.LOV_ID=CLM.LOV_ID AND OBJECT_ID IN  (6702

    • Moved by Allen Chen - MSFT Thursday, April 29, 2010 5:57 AM off topic (From:SQL Azure — Getting Started)
    Wednesday, April 28, 2010 8:24 AM

Answers

All replies