When using the CLUSTER BY clause in a COMPACT statement, and the table has a clustered index, then you must specify the clustered index that already exists. If the table does not have a clustered index, then any index can be specified.
Restriction: This topic applies to Windows environments only.
