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.