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.
|