Primary key Index Clustering Data Stores Property

Official Content
This documentation is valid for:

Define whether the primary key index is created ‘clustered’ or ‘not clustered’ at the DBMS Options level.

Values

Clustered The index is created with the following syntax:  “CREATE UNIQUE CLUSTERED INDEX …”. This is the default value.
Not clustered The index is created with the following syntax:  “CREATE UNIQUE NONCLUSTERED INDEX …”

Description

This DBMS Option applies when the Primary key Definition property is ‘Index’. Clustered means that the index order at a physical level matches the logical order. 

Scope

Languages: .NET, Java, Visual Basic, Visual FoxPro
DBMS: Informix and SQL Server

See Also