索引查詢器 的英文怎麼說
中文拼音 [suǒyǐnzhāxúnqì]
索引查詢器
英文
index/search subsystem- 索 : Ⅰ名詞1 (大繩子; 大鏈子) a large rope 2 (姓氏) a surname Ⅱ動詞1 (搜尋; 尋找) search 2 (要; ...
- 引 : Ⅰ動詞1 (牽引; 拉) draw; stretch 2 (引導) lead; guide 3 (離開) leave 4 (伸著) stretch 5 (...
- 查 : 查名詞1. [植物學] (山查) hawthorn; haw2. (姓氏) a surname
- 詢 : 動詞(詢問) ask; inquire
- 器 : 名詞1. (器具) implement; utensil; ware 2. (器官) organ 3. (度量; 才能) capacity; talent 4. (姓氏) a surname
- 索引 : index; indexing; key; repertory; subscript; concordance
- 查詢 : inquire about; [計算機] query; inquiry; polling
-
The default indexer allows generic access to the query parameters maintained by this object
)的參數值。默認索引器允許對此對象維護的查詢參數進行一般訪問。A multiple index hint also enforces index anding and the query optimizer applies as many conditions as possible on each index accessed
多索引提示還強制執行索引and運算,查詢優化器將對每個被訪問的索引應用盡可能多的條件。The query optimizer treats the view like a table with clustered index
查詢優化器將視圖當成包含聚集索引的表處理。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查詢優化器可將更多查詢與索引視圖相匹配,包括包含標量表達式、標量聚合函數與用戶定義函數、間隔表達式以及等價條件的查詢。To save on i o operations, the query processor may choose to scan another index instead of performing a table scan
為了節省i / o操作,查詢處理器可以選擇掃描另一個索引,而不是執行表掃描。The optimizer won t use an index if the query retrieves a large amount of data from a table
如果查詢從一個表檢索大量數據,優化器就不會使用索引。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語句使用鎖定方法。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位文件級加密以及密碼保護和查詢優化器。The content inside the index servers is similar to the index in the back of a book - it tells which pages contain the words that match the query
在索引伺服器內的內容,就像是書本後面的索引一般-它會告知使用者哪個網頁包含符合查詢的字詞。The query processor uses the primary xml index for queries that involve
查詢處理器將主xml索引用於涉及How indexes are used by the query optimizer
查詢優化器如何使用索引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
因此,查詢優化器的任務是只在索引或索引組合能提高性能時才選擇它,而在索引檢索有礙性能時則避免使用它。The web server sends the query to the index servers
網頁伺服器將查詢傳送給索引伺服器。The query processor uses statistics to help select the most appropriate index for efficient processing
查詢處理器使用統計信息來幫助選擇最合適的索引以便進行高效處理。Spider downloads pages from web ; parser analyses the pages in order to set up index ; the index lists the file in a way which is easy to be searched and stores it in the index database ; the searching device realizes users calculation of inquire keyword and match degree of goal files ; user interface provides users a web page which can input inquiring request and customize inquiring results, and returns the results to browser after being formatted
Spider從web上下載頁面;分析器對下載頁面的內容進行分析以用於建立索引;索引器將文檔表示為一種便於檢索的方式並存儲在索引數據庫中;檢索器實現用戶查詢關鍵詞和目標文檔匹配度的計算;用戶介面為用戶提供一個輸入查詢請求,定製查詢結果的web頁面並將查詢結果格式化后返回給瀏覽器。However, if no indexes are available, the query optimizer must use a table scan
但如果沒有索引,則查詢優化器必須掃描表。Enterprise information system framework provides a series of reusable groupware, such as persistence layer which introduces dynamic value object 、 value list hander and command pattern, it encapsulates the detail of accessing database and affords the interface of different persistence layer framework ; basing on asynchronous javascript and xml ( ajax for short ), we develops the client validity check engine 、 dynamic cascading menu and common 、 dynamic tree structure groupware, as well as a set of tag library which include query 、 pagination 、 cache an so on. they reduce the code redundancy and predigests the development of interface layer enormously ; the security subsystem which is based on secure socket layer ( ssl for short ) and role - based access control ( rbac for short ) ensures the data security transmission and privilege control. furthermore, the model of enterprise application integration ( eai for short ) which based on web services, it supply some helpful explore for the sake of system integration and data communion for the future
企業信息系統框架提供了一系列可復用組件,例如採用動態vo 、值列表處理器以及命令模式的持久層組件,封裝了數據庫訪問細節,並為不同的持久層框架提供調用介面;基於ajax ( asynchronousjavascriptandxml )技術的客戶端校驗引擎、動態級聯菜單以及通用動態樹型結構組件,一系列查詢、分頁、緩存等標簽庫則減少了表示層的代碼冗餘,簡化了表示層開發;基於ssl登錄以及基於角色的訪問控制的安全子系統則初步實現了數據安全傳輸和權限控制;此外基於web服務的企業應用集成模型為今後系統集成、數據共享提供了有益探索。Awareness of all applicable remote indexes can help the federated query optimizer generate better execution plans
清楚所有適用的遠程索引有助於聯邦查詢優化器生成更好的執行計劃。When the query optimizer analyzes a query to determine the best execution plan, it automatically generates information about indexes that would improve query performance even if the indexes do not exist
當查詢優化器分析查詢以確定最佳執行計劃時,即使沒有索引,優化器也能自動生成可提高查詢性能的索引的相關信息。Database engine tuning advisor analyzes these workloads to recommend indexes or partitioning strategies that will improve your server s query performance
數據庫引擎優化顧問將分析這些工作負荷以便建議要使用的索引或分區策略來改善服務器的查詢性能。分享友人