English version of all error messages you can encounter while programming
  |   ABOUT


Localized version

找不到查询计划,因为优化器超出了在搜索 USE PLAN 提示中指定的计划时允许的操作数目。首先考虑删除 USE PLAN 提示。然后,如有必要,请考虑 (1) 更新统计信息,(2) 使用诸如联接提示、索引提示或 OPTIMIZE FOR 提示之类的其他提示,(3) 重写查询或将查询拆分为两个或多个单独的查询。

Click to search this error in Google

English version

A query plan could not be found because optimizer exceeded number of allowed operations while searching for plan specified in USE PLAN hint. First consider removing USE PLAN hint. Then if necessary consider (1) updating statistics, (2) using other hints such as join hints, index hints, or the OPTIMIZE FOR hint, (3) rewriting query or breaking it down into two or more separate queries.

Click to search this error in Google



Localized version
 Chinese (Simplified) Legacy

Error category
 SQL Server

Other localized versions
9 versions





Copyright © dotmedias 2012 Launched in 2012, to help programmers finding solutions