Neoview SQL Reference Manual (R2.2)

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
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
Versioning Considerations..............................................................................................................68
Example of CREATE SYNONYM....................................................................................................68
CREATE TABLE Statement...................................................................................................................69
Syntax Description of CREATE TABLE...........................................................................................71
Considerations for CREATE TABLE................................................................................................73
Considerations for CREATE VOLATILE TABLE............................................................................74
Considerations for CREATE TABLE LIKE......................................................................................74
Reserved Table Names.....................................................................................................................74
Authorization and Availability Requirements................................................................................74
Limits for Tables..............................................................................................................................74
Calculating Row Size.......................................................................................................................75
Creating Partitions Automatically...................................................................................................75
Record Format.................................................................................................................................75
Generating Unique Values For a Column.......................................................................................75
Neoview SQL Extensions to CREATE TABLE................................................................................77
DISK POOL......................................................................................................................................77
Considerations for DISK POOL.................................................................................................77
Restrictions for DISK POOL.......................................................................................................78
Examples of CREATE TABLE..........................................................................................................78
Examples of CREATE TABLE AS....................................................................................................79
CREATE TRIGGER Statement..............................................................................................................81
Syntax Description of CREATE TRIGGER......................................................................................81
Considerations for CREATE TRIGGER...........................................................................................82
Authorization and Availability Requirements...........................................................................82
Trigger Types..............................................................................................................................82
Table of Contents 5