Neoview SQL Reference Manual (R2.5)

occurs. If you want to access the data while populating the index, use the POPULATE INDEX
utility.
You cannot access an index directly.
Limits on Indexes
For nonunique indexes, the sum of the lengths of the columns in the index plus the sum of the
length of the clustering key of the underlying table cannot exceed 2048 bytes. For unique indexes,
the sum of the lengths of the columns in the index cannot exceed 2048 bytes.
There is no restriction on the number of indexes per table.
Example of CREATE INDEX
• This example creates an index on two columns of a table:
CREATE INDEX xempname
ON persnl.employee (last_name, first_name);
62 SQL Statements