Sets or returns a value that indicates whether an Index object represents a clustered index for a table (Microsoft Access workspaces only). Read/write Boolean.
Syntax
expression .Clustered
expression An expression that returns a Index object.
Remarks
The setting or return value is a Boolean data type that is True if the Index object represents a clustered index.
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.
Note
- Microsoft Access database engine databases ignore the Clustered property because the Microsoft Access 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.
|