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 问题”,并将其取代为新的反馈系统。 有关详细信息,请参阅:提交和查看相关反馈