Neoview SQL Reference Manual (R2.2)

SQL Tables
For more information, see “CREATE TABLE Statement” (page 69), “CREATE INDEX Statement”
(page 58), and “ALTER VIEW Statement” (page 51).
Automatically Creating Partitions
When creating a table users can specify that the table is not partitioned using the NO PARTITION
clause. The default is for the table to be partitioned.
Users may also specify the MAX TABLE SIZE clause that will be used to decide on the table
extent sizes. If this option is not specified Neoview SQL will decide. If the table is partitioned
then the table is partitioned across all the disk volumes on the system.
232 SQL Language Elements