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 (Traditional) Legacy

Error category
 SQL Server

Other localized versions
9 versions





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