Table Size Specifications

By default, when a SQL table is created, it will have a small maximum size, in the order of 100 MBytes per partition. For production environments, the table size must be large. You can set the initial and maximum size of a table at creation time through physical file attributes known as 'extent size' and 'maximum extents'. New attributes are added to determine the extent sizes of the table. For more information on attributes, see Attributes.

The CREATE TABLE statement is enhanced to include two new syntax options:

CREATE TABLE table
                { (table-element [,table-element]...) | like-spec }
                [file-option ]
file-option is:
STORE BY store-option
| LOCATION [\node.]$volume[.subvolume.file-name]
[NAME partition-name]
| partn-file-option
| ATTRIBUTE[S] attribute [,attribute]...
| INITIAL TABLE SIZE table_size
| MAX TABLE SIZE size

NOTE:

The syntax for CREATE TABLE here is not complete and is only a snippet to show the new syntax options.

INITIAL TABLE SIZE initial_table_size

Determines the size of the primary extent. initial_table_size is in bytes.
MAX TABLE SIZE max_table_size

Determines the maximum size for the table. max_table_size is in bytes.