ASE Create Index Preferences

Table 1. Adaptive Server Enterprise Create Index Preferences: Storage
Property	Description
Unique	Select yes to make the index unique. The default is no.
Clustered	Select yes to make a clustered index. The default is no.
Ignore Duplicate Key	Select yes to ignore duplicate keys. The default is no.
Duplicate Row	Select allow to allow duplicate rows. The default is do not allow.
Fill Factor	Enter a value in the numeric field from 0 to 100. An entry of 0 results in the creation of clustered indexes with completely full pages, if you enabled the Clustered property, and nonclustered indexes with completely full leaf pages, if you did not enable the Clustered property. By default, this property is not selected, and the numeric value is 0.
Rows Per Page	Specify the rows per page. The default is 0. For page size of 2K: 0 to 183 For page size of 16K: 0 to 1486
Reserve Page Gap	Specify the reserve page gap, from 0 to 255, which is a ratio of empty pages to filled pages. For example, if you specify a reserve page gap of 8, operations fill seven pages and leave an eighth page empty. The default is 0.

Table 2. Adaptive Server Enterprise Create Index preferences: Miscellaneous
Property	Values	Description
Cache Strategy: Most Recently Used Replacement	checked, unchecked	Replace pages in cache according to the most recent use (default).
Cache Strategy: Large Buffer Prefetch	checked, unchecked	Enable a large buffer into which pages are prefetched (default).
Data Already Sorted	yes, no	If data is already sorted, use this property to save time creating an index. This property is available for both clustered and nonclustered indexes. The default is no.
Number of Consumer Processes	non-zero integer	Specify the number of consumer processes involved in creating an index. Enter a nonzero integer in the numeric field. The default is 0.
Statistics Step	non-zero integer	Identifies the number of steps used when updating statistics. The default is 20.

Table 3. Adaptive Server Enterprise Create Index preferences: Partition
Property	Description
Create Local Partitioned Index (Adaptive Server Enterprise 15.x only)	Create a local partitioned index. This option is not enabled by default.