query optimizer 中文意思是什麼

query optimizer 解釋
查詢優化器
  • query : n 1 質問；詢問；疑問，懷疑。2 敢問，請問〈在疑問句前單獨使用〉。3 【印刷】（打在原稿或校樣上的）...
  • optimizer : 求解器
  1. The query optimizer treats all internal system tables as if the auto create statistics setting is on, regardless of the actual setting

    無論auto _ create _ statistics實際設置情況如何，查詢優化器在處理所有內部系統表時，都按照它被設置為on的情況來處理。
  2. A multiple index hint also enforces index anding and the query optimizer applies as many conditions as possible on each index accessed

    多索引提示還強制執行索引and運算，查詢優化器將對每個被訪問的索引應用盡可能多的條件。
  3. The query optimizer treats the view like a table with clustered index

    查詢優化器將視圖當成包含聚集索引的表處理。
  4. Because the sql server 2005 query optimizer typically selects the best execution plan for a query, we recommend that hints, including

    由於sql server 2005查詢優化器通常為查詢選擇最優執行計劃，因此建議只將提示包括
  5. Disabling automatic statistics recomputation can cause the query optimizer to choose a less optimal strategy for queries that involve the specified table

    禁用自動統計信息重新計算會導致查詢優化器為涉及指定表的查詢選擇非最佳的策略。
  6. Because the sql server 2005 query optimizer typically selects the best execution plan for a query, we recommend that hints, including query hint, be used only as a last resort by experienced developers and database administrators

    由於sql server 2005查詢優化器通常為查詢選擇最優執行計劃，因此建議只將提示（包括< query _ hint > ）用作經驗豐富的開發人員和數據庫管理員的最終手段。
  7. Because the sql server 2005 query optimizer typically selects the best execution plan for a query, we recommend that hints, including table hint, be used only as a last resort by experienced developers and database administrators

    由於sql server 2005查詢優化器通常為查詢選擇最優執行計劃，因此我們建議，只有在萬般無奈的情況下才由經驗豐富的開發人員和數據庫管理員使用提示（包括< table _ hint > ） 。
  8. The sql server 2005 query optimizer can match more queries to indexed views than in previous versions, including queries that contain scalar expressions, scalar aggregate and user - defined functions, interval expressions, and equivalency conditions

    與以前各版本相比， sql server 2005查詢優化器可將更多查詢與索引視圖相匹配，包括包含標量表達式、標量聚合函數與用戶定義函數、間隔表達式以及等價條件的查詢。
  9. Therefore, more challenges have arisen for query optimization in database grid than traditional distributed database. following this observation, the design of a query optimizer in dartgrid ii is presented, and a heuristic, dynamic and parallel query optimization approach to processing query in database grid is proposed. a set of semantic tools supporting relational database integration and semantic - based information browsing has also been implemented to realize the above vision

    克服數據庫網格特性所帶來的困難需要為數據庫網格提供全局一致的數據表達模式各結點數據模式到全局模式之間的映射方法各結點之間負載平衡和結點動態加入和退出系統的控制策略數據庫網格查詢優化器結構設計以及一整套適合數據庫網格的查詢優化演算法。
  10. Specifies that the query optimizer use a table scan, one or more indexes, or a locking method with this table or view and for this select, insert, update, or delete statement

    指定查詢優化器使用一個表掃描、一個或多個索引，或為當前表或視圖以及當前的select 、 insert 、 pdate或delete語句使用鎖定方法。
  11. Sql server mobile also provides multiple - connection access to a database, multiple - column indexes and matching index limits, transaction support, referential integrity, 128 - bit file - level encryption and password protection, and a query optimizer

    Sql server mobile還提供對數據庫的多連接訪問、多列索引和匹配的索引限制、事務支持、引用完整性、 128位文件級加密以及密碼保護和查詢優化器。
  12. Simple instructs the query optimizer to attempt

    Simple指示查詢優化器嘗試進行
  13. Query execution costs are estimated by the query optimizer

    由查詢優化器估計查詢執行開銷。
  14. Advanced query optimizer

    高級查詢優化器
  15. How indexes are used by the query optimizer

    查詢優化器如何使用索引
  16. A compact database engine and a robust query optimizer

    壓縮的數據庫引擎和強大的查詢優化器。
  17. When the sql server query optimizer recognizes a query that matches

    當sql server查詢優化器識別與
  18. This makes sure that the plan guide is used by the query optimizer

    這將確保計劃指南可由查詢優化器使用。
  19. Approximate query execution costs are estimated by the query optimizer

    由查詢優化器估計查詢執行的大致開銷。
  20. Therefore, the task of the query optimizer is to select an index, or combination of indexes, only when it will improve performance, and to avoid indexed retrieval when it will hinder performance

    因此，查詢優化器的任務是只在索引或索引組合能提高性能時才選擇它，而在索引檢索有礙性能時則避免使用它。
分享友人
分享到 Line

分享到臉書