Neoview Database Administrator's Guide (R2.2)

Table 4-1 Notes for Creating Tables (continued)
NotesTable Option
• Only ON REQUEST materialized aggregate views are supported
• Only INITIALIZATION ON REQUEST type for materialized views is supported
• Creation of the materialized view is specified:
— Query expression for the materialized view. This includes the SELECT FROM,
WHERE, and GROUP BY clauses.
— For HASH BY, you must choose from the list of GROUP BY columns.
Materialized Views
• Column names can be up to 128 characters in length.
• Indexes
— The maximum combined length of the columns for an index is 255 bytes. A
nonunique index consists of columns and a clustering key. A unique index
consists of columns only.
— There is no restriction on the number of indexes per table but creating many
indexes on a table can increase compile time.
— There are no restrictions on the number of partitions an index supports, but
beyond 512, performance and memory issues may occur.
• Partitions
— There are no restrictions on the number of partitions a table can support, but
beyond 512, performance and memory issues may occur.
• Schema names can be up to 128 characters in length.
• Tables
— Table names can be up to 128 characters in length.
— The maximum length of a row is 4040 bytes, but not all of that is available.
Depending on data types you use, if NULL is an option, some bytes might
be reserved for internal use.
Limits
Neoview SQL Table Options 35