Clustered Property
Version: Available or changed with runtime version 1.0.
Sets a value that indicates whether the key also defines the clustered index in the database.
By default the primary key is configured as the clustered key.
Applies to
- Table Key
Note
The Clustered
property cannot be used in table extension objects.
Property value
True if the index is clustered, otherwise false. The default is false.
Syntax
Clustered = true;
Remarks
A clustered index determines the physical order in which records are stored in the table. Using a clustered key can improve the time it takes to retrieve records.
There can be only one clustered key on a table.
Example
The following example defines a secondary key to be a clustered index.
keys
{
// the first key defined in the keys section is the primary key
key(PrimaryKey; ID)
{
Clustered = false;
}
key(CustomerInfo; Name,Address,City)
{
Clustered = true;
}
}
See Also
意見反應
https://aka.ms/ContentUserFeedback。
即將登場:在 2024 年,我們將逐步淘汰 GitHub 問題作為內容的意見反應機制,並將它取代為新的意見反應系統。 如需詳細資訊,請參閱:提交並檢視相關的意見反應