If you disable automatic statistics recomputation , you must manually update the statistical information 如果禁用自動統(tǒng)計信息重新計算,則必須手動更新統(tǒng)計信息。
To restore automatic statistics recomputation , reissue update statistics without the norecompute option or run 若要恢復自動統(tǒng)計信息重新計算功能,可重新發(fā)出不使用norecompute選項的update statistics或執(zhí)行
Disabling automatic statistics recomputation can cause the query optimizer to choose a less optimal strategy for queries that involve the specified table 禁用自動統(tǒng)計信息重新計算會導致查詢優(yōu)化器為涉及指定表的查詢選擇非最佳的策略。
Disabling automatic recomputation of distribution statistics may prevent the query optimizer from picking optimal execution plans for queries involving the table 如果禁用分布統(tǒng)計的自動重新計算,可能會妨礙查詢優(yōu)化器為涉及該表的查詢選取最佳執(zhí)行計劃。
Disabling automatic recomputation of distribution statistics may prevent the query optimizer from picking optimal execution plans for queries that involve the table 如果禁用分發(fā)統(tǒng)計信息的自動重新計算,可能會阻止查詢優(yōu)化器為涉及該表的查詢挑選最佳執(zhí)行計劃。