Clustered Property

       

Sets or returns a value that indicates whether an Index object represents a clustered index for a table (Microsoft Jet workspaces only).

Settings and Return Values

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

Remarks

Some IISAM desktop database formats use clustered indexes. A clustered index consists of one or more nonkey fields that, taken together, arrange all records in a table in a predefined order. A clustered index provides efficient access to records in a table in which the index values may not be unique.

The Clustered property 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.

Notes

?Microsoft Jet databases ignore the Clustered property because the Microsoft Jet database engine doesn't support clustered indexes.

 

?For ODBC data sources the Clustered property always returns False; it does not detect whether or not the ODBC data source has a clustered index.