Sybase IQ Create Index Preferences

The Sybase IQ create index preferences determine the default values for creating new IQ indexes.

Table 1. Sybase IQ Create Index preferences: Index
Property	Description
Index Type	High Group — the High Group index is commonly used to join columns with integer datatypes. High Non-Group — add High Non-Group index when you need to do range searches. A High Non-Group index requires approximately three times less disk space than a High Group index requires. DATE — a DATE index is used on columns of data type DATE to process certain queries involving date quantities. Time — the TIME index is used on columns of data type TIME to process certain queries involving time quantities. Compare — a Compare index is an index on the relationship between two columns. You may create Compare indexes on any two distinct columns with identical datatypes, precision, and scale. The Compare index stores the binary comparison (<, >, or =) of its two columns. Word — this index allows you to store words from a column string of CHAR and VARCHAR data. Date Time — the Date Time index is used on columns of datatype DATETIME or TIMESTAMP to process certain queries involving datetime quantities. Low Fast — this index is ideal for columns that have a very low number of unique values (under 1,000) such as sex, Yes/No, True/False, number of dependents, wage class, and so on. Low Fast is the fastest index in Sybase IQ.
Unique	Make indexes unique.
Delimiter String	Specify a delimiter string. Enter the delimiter string in the corresponding text field.
Max Size of String	Specify a maximum string length. Enter the string length in the corresponding text field.
Notify Count	Change the number of records after which you receive a progress message.By default, after every 100,000 records are inserted and loaded into indexes, you receive a progress message. To prevent progress messages, specify a value of 0.
Parallel	Allow more than one index to be created simultaneously.

Table 2. Sybase IQ Create Index preferences: Index Advisor
Property	Description
Index Advisor Option	Create entries in the message log or query plan to suggest additional indexes that might improve performance. Select Temporary to set the Index Advisor for a connection. Select Permanent to set the Index Advisor for a user or group.
Index Advisor Maximum Rows	Issue a maximum number of messages to the message log or query plan. Select Temporary to set the Index Advisor for a connection. Select Permanent to set the index advisor for a user or group. Enter a maximum number of rows in the corresponding text field.
Apply Index Advices Automatically	Select this property to automatically apply messages from the Index Advisor.