Clustered Property

Applies To

Index Object.

Description

Sets or returns a value that indicates whether an Index object represents a clustering index for a table. This property setting is read/write for a new Index object not yet appended to a collection and read-only for an existing Index object in an Indexes collection.

Settings and Return Values

The setting or return value is True if the Index object represents a clustering index. The data type is Boolean.

Remarks

A clustering index consists of one or more nonkey fields that, taken together, arrange all records in a table in a predefined order. A clustering index provides efficient access to records in a table in which the index values may not be unique.

Notes

The Clustered property is ignored for databases that use the Microsoft Jet database engine because the Jet database engine doesn't support clustering indexes.
For ODBC databases, the Clustered property always returns False (0); it does not detect whether the ODBC database has a clustering index or not.
You don't have to create indexes for tables, but in large, unindexed tables, accessing a specific record can take a long time. The Attributes property of each Field object in the Index object determines the order of records and consequently determines the access techniques to use for that index.

See Also

Attributes Property, Primary Property, Unique Property.