Neoview SQL Reference Manual (R2.4)

Indexes
An index is an ordered set of pointers to rows of a table. Each index is based on the values in
one or more columns.
There is always a one-to-one correspondence between index rows and base table rows.
SQL Indexes
Each row in a Neoview SQL index contains:
• The columns specified in the CREATE INDEX statement
• The clustering key of the underlying table (the user-defined clustering key)
An index name is an SQL identifier. Indexes have their own namespace within a schema, so an
index name might be the same as a table or constraint name. However, no two indexes in a
schema can have the same name.
See “CREATE INDEX Statement” (page 59).
254 SQL Language Elements