indexed view 中文意思是什麼
indexed view
解釋
索引查看-
Is the table or indexed view for which to run integrity checks
要進行完整性檢查的表或索引視圖。 -
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
禁用的聚集索引或禁用的索引視圖 -
The definition of an indexed view must be deterministic
索引視圖的定義必須是確定性的。 -
Indexed view definitions can also now contain scalar aggregate and user - defined functions with certain restrictions
現在，索引視圖定義也可以包含帶有一定限制的標量聚合函數和用戶定義函數。 -
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
具有手動篩選器和手動視圖並且基於日誌的索引視圖項目。 -
Indexed view logbased manualview log - based indexed view article with manual view
具有手動視圖並且基於日誌的索引視圖項目。 -
Does the indexed view compute a sum aggregate over values of type float or real
索引視圖對float或real類型的值計算sum聚合嗎？ -
Specifies the percentage of the table or indexed view, or the number of rows to sample when collecting statistics for larger tables or views. number
指定在收集較大型的表或視圖的統計信息時，要抽樣的表或索引視圖的百分比或者行數。 -
Api cursor query contains an indexed view with a unique access path, but not at the base - table level
Api游標查詢包含具有唯一訪問路徑但不處于基表級別的索引視圖。 -
For every partition used by a table heap or clustered table, index, or indexed view, there is one row overflow data allocation unit
對于表（堆或聚集表） 、索引或索引視圖使用的每個分區，都有一個row _ overflow _ data分配單元。 -
In the latter case, accessing an indexed view can be prevented by using the option expand views query hint
在後一種情況中，使用option （ expand views ）查詢提示可阻止訪問索引視圖。 -
The indexed view is used by the query optimizer to produce the query plan
查詢優化器使用該索引視圖生成查詢計劃。
分享友人