clustered index 中文意思是什麼
clustered index
解釋
叢集索引-
A good effect is made by using the technology of horizontal subarea and building clustered index. in the testing environment on local machine, the response time of outputting 18, 422 pieces of records from the spot data table induing about 28 million pieces of records is about 8 second
使用水平分區的技術和建立聚集索引的技術取得了較好的效果，在本機測試環境中，從測點數據表近2800萬條記錄中輸出匹配量為18422條記錄的時間約為8秒。 -
Drop the clustered index on the view and re - create it without specifying the ignore dup key option
刪除視圖的聚集索引，然後重新創建它，而不指定ignore _ dup _ key選項。 -
For best performance, a clustered index is recommended
為了獲得最佳性能，建議使用clustered索引。 -
The query optimizer treats the view like a table with clustered index
查詢優化器將視圖當成包含聚集索引的表處理。 -
Clustered index structures
聚集索引結構 -
For a clustered table, the row locator is the clustered index key
對于聚集表，行定位器是聚集索引鍵。 -
Explains how data rows are stored in a clustered index and how they are accessed and maintained
說明如何將數據行存儲在聚集索引中，以及如何對其進行訪問和維護。 -
If a table has no clustered index, its data rows are stored in an unordered structure called a heap
如果表沒有聚集索引，則其數據行存儲在一個稱為堆的無序結構中。 -
The statement acquires 3, 000 row locks in the clustered index for
的聚集索引中獲取3 ， 000個行鎖，在 -
And at least 5, 000 row locks in the clustered index for
的聚集索引中獲取至少5 ， 000個行鎖，但是仍無法訪問 -
Disabled clustered index or disabled indexed view
禁用的聚集索引或禁用的索引視圖 -
The data rows are stored in order based on the clustered index key
數據行基於聚集索引鍵按順序存儲。 -
When primary is specified, a clustered index is created with the clustered key formed from the clustering key of the user table and an xml node identifier
指定primary時，會使用由用戶表的聚集鍵形成的聚集鍵和xml節點標識符來創建聚集索引。 -
The only time the data rows in a table are stored in sorted order is when the table contains a clustered index
只有當表包含聚集索引時，表中的數據行才按排序順序存儲。 -
When a clustered index is dropped, the index definition is removed from metadata and the data rows that were stored in the leaf level of the clustered index are stored in the resulting unordered table, a heap
刪除聚集索引時，將從元數據中刪除索引定義，並且存儲于聚集索引葉級別的數據行將存儲到生成的未排序表（堆）中。 -
Creating a unique clustered index on a view improves query performance because the view is stored in the database in the same way a table with a clustered index is stored
為視圖創建唯一聚集索引可以提高查詢性能，因為視圖在數據庫中的存儲方式與具有聚集索引的表的存儲方式相同。 -
An index on a view materializes executes, the view and the result set is permanently stored in a unique clustered index in the same way a table with a clustered index is stored
視圖的索引將具體化（執行）視圖，並將結果集永久存儲在唯一的聚集索引中，而且其存儲方法與帶聚集索引的表的存儲方法相同。 -
In sql server 2005 enterprise edition, the number of processors employed to run a single alter table add index based constraint or drop clustered index constraint statement is determined by the
配置選項和當前工作負荷，確定運行單個alter table add （基於索引） constraint或drop （聚集索引） constraint語句採用的處理器數。 -
Clustered index design guidelines
聚集索引設計指南 -
For an empty table, this approach is significantly faster than creating the clustered index after importing the data, as it eliminates the sorting step
對于空表，此方法明顯快于導入數據后再創建聚集索引，因為它不需要執行排序。
分享友人