Neoview SQL Reference Manual (R2.3)

Considerations for CREATE INDEX...............................................................................................59
Authorization and Availability Requirements...........................................................................59
Limits on Indexes.......................................................................................................................59
Example of CREATE INDEX...........................................................................................................59
CREATE MATERIALIZED VIEW Statement........................................................................................60
Syntax Description of CREATE MATERIALIZED VIEW................................................................60
Considerations for CREATE MATERIALIZED VIEW....................................................................62
Types of Materialized Views...........................................................................................................62
Authorization..................................................................................................................................62
Materialized Views Clustering........................................................................................................63
Materialized Views Using Other Materialized Views.....................................................................63
Single Delta Materialized Views.....................................................................................................63
DML Operations on Materialized Views........................................................................................63
Indexes and Materialized Views.....................................................................................................63
Joins.................................................................................................................................................64
Restrictions for CREATE MATERIALIZED VIEW..........................................................................64
MJV (Materialized Join View)....................................................................................................64
MAV (Materialized Aggregate View) on a Single Table............................................................64
DML Operations on Materialized Views...................................................................................64
Example of CREATE MATERIALIZED VIEW................................................................................64
CREATE MVGROUP Statement...........................................................................................................66
Authorization and Availability Requirements................................................................................66
Example of CREATE MVGROUP....................................................................................................66
CREATE SCHEMA Statement..............................................................................................................67
Syntax Description of CREATE SCHEMA......................................................................................67
Considerations for CREATE SCHEMA...........................................................................................67
Reserved Schema Names...........................................................................................................67
Example of CREATE SCHEMA.......................................................................................................67
CREATE SYNONYM Statement...........................................................................................................68
Syntax Description of CREATE SYNONYM ..................................................................................68
Considerations.................................................................................................................................68
Example of CREATE SYNONYM....................................................................................................68
CREATE TABLE Statement...................................................................................................................69
Syntax Description of CREATE TABLE...........................................................................................71
Considerations for CREATE TABLE................................................................................................74
Considerations for CREATE SET TABLE........................................................................................74
Restrictions.................................................................................................................................74
Considerations for CREATE VOLATILE TABLE............................................................................74
Considerations for CREATE TABLE LIKE......................................................................................74
Reserved Table Names.....................................................................................................................75
Authorization and Availability Requirements................................................................................75
Limits for Tables..............................................................................................................................75
Calculating Row Size.......................................................................................................................75
Creating Partitions Automatically...................................................................................................76
Record Format.................................................................................................................................76
Generating Unique Values For a Column.......................................................................................76
Neoview SQL Extensions to CREATE TABLE................................................................................78
DISK POOL......................................................................................................................................78
Considerations for DISK POOL.................................................................................................78
Restrictions for DISK POOL.......................................................................................................78
Examples of CREATE TABLE..........................................................................................................78
Examples of CREATE SET TABLE..................................................................................................80
Examples of CREATE TABLE AS....................................................................................................80
CREATE TRIGGER Statement..............................................................................................................82
Syntax Description of CREATE TRIGGER......................................................................................82
Table of Contents 5