索引視圖 的英文怎麼說
中文拼音 [suǒyǐnshìtú]
索引視圖
英文
indexed view- 索 : Ⅰ名詞1 (大繩子; 大鏈子) a large rope 2 (姓氏) a surname Ⅱ動詞1 (搜尋; 尋找) search 2 (要; ...
- 引 : Ⅰ動詞1 (牽引; 拉) draw; stretch 2 (引導) lead; guide 3 (離開) leave 4 (伸著) stretch 5 (...
- 視 : Ⅰ動詞1. (看) look at 2. (看待) regard; look upon 3. (考察) inspect; watch Ⅱ名詞(姓氏) a surname
- 圖 : Ⅰ名詞1 (繪畫表現出的形象; 圖畫) picture; chart; drawing; map 2 (計劃) plan; scheme; attempt 3...
- 索引 : index; indexing; key; repertory; subscript; concordance
-
Is the table or indexed view for which to run integrity checks
要進行完整性檢查的表或索引視圖。For example, if the test server is running sql server standard edition, database engine tuning advisor will not include indexed views, partitioning, and online operations in its recommendations even if the production server is running sql server enterprise edition
例如,如果測試服務器運行sql server standard edition ,則即使生產服務器運行sql server enterprise edition ,數據庫引擎優化顧問也不會建議使用索引視圖、分區和聯機操作。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查詢優化器可將更多查詢與索引視圖相匹配,包括包含標量表達式、標量聚合函數與用戶定義函數、間隔表達式以及等價條件的查詢。Checks the integrity of all the pages and structures that make up the table or indexed view
檢查組成表或索引視圖的所有頁和結構的完整性。Index maintenance may increase the time that it takes to perform modifications, inserts, updates, or deletes, to the underlying table or indexed view
索引維護可能會增加對基礎表或索引視圖執行修改、插入、更新或刪除操作所需的時間。Disabled clustered index or disabled indexed view
禁用的聚集索引或禁用的索引視圖Real value and the view is small, compare the indexed and calculated view visually and decide whether the differences are significant
值的sum操作中,並且視圖較小,請從視覺上比較索引視圖和計算視圖,以確定差異是否顯著。The definition of an indexed view must be deterministic
索引視圖的定義必須是確定性的。The logical consistency of any indexed views present in the database is checked during this phase
在該階段中將檢查數據庫中存在的任何索引視圖的邏輯一致性。Indexed views materialized views
索引視圖(具體化視圖)Database engine tuning advisor can use constants in a workload to make recommendations that include indexed views with selection conditions, or range partition functions for partitioned indexes
數據庫引擎優化顧問可能使用工作負荷中的常量提出建議,請求包含帶選擇條件的索引視圖,或用於已分區索引的范圍分區函數。Indexed view definitions can also now contain scalar aggregate and user - defined functions with certain restrictions
現在,索引視圖定義也可以包含帶有一定限制的標量聚合函數和用戶定義函數。Validates the service broker data in the database
驗證數據庫中每個索引視圖的內容Dbcc checktable performs consistency checks on a single table or indexed view and all its nonclustered and xml indexes, unless the noindex option is specified. to perform dbcc checktable on every table in the database, use
除非指定noindex選項,否則, dbcc checktable將對單個表或索引視圖及其所有非聚集索引以及xml索引執行物理一致性檢查。Of every table and indexed view in the filegroup
文件中的每個表和索引視圖的Indexed view logbased log - based indexed view article
基於日誌的索引視圖項目。Log - based indexed view article with manual view
具有手動視圖並且基於日誌的索引視圖項目。Log - based indexed view article with manual filter
具有手動篩選器並且基於日誌的索引視圖項目。Log - based indexed view article
基於日誌的索引視圖項目。Log - based indexed view article with manual filter and manual view
具有手動篩選器和手動視圖並且基於日誌的索引視圖項目。分享友人