Define whether the primary key index is created ‘clustered’ or ‘not clustered’ at the DBMS Options level.
| 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 …” |
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.
Languages: .NET, Java, Visual Basic, Visual FoxPro
DBMS: Informix and SQL Server