use_clustered_index

Default: False for index. True for primary key.
Range: True or False
Applies to: SQL Server Client only

The use_clustered_index parameter applies to all data tables. You can override its setting on a table-by-table basis via the DATATABLES control table, dt_options column, DTOPT_Clustered_Index bit.

Use this parameter as follows:

• Set use_clustered_index to True if you want a clustered index for all or most tables.
• For all tables, just set this parameter to True.
• For most tables, set this parameter to True and then reset DTOPT_Clustered_Index for those tables for which you do not want a clustered index.
• Set use_clustered_index to False if you want no clustered indexes on all tables, or if you want clustered indexes on only a few tables.
• For no clustered index on all tables, just set this parameter to False.
• For clustered indexes on only a few tables, set this parameter to False and then set DTOPT_Clustered_Index for those tables for which you do want a clustered index.

To reset or set DTOPT_Clustered_Index, see "dt_options" in DATATABLES. Typically you would do this via user scripts.