Neoview Database Administrator's Guide (R2.3)

4 Planning Your Database
This chapter describes:
• “Guidelines for Database Administrators” (page 31)
• “Neoview SQL Table Options” (page 31)
Guidelines for Database Administrators
• CREATE TABLE statement
— You can create partitioned and nonpartitioned tables. When you create a partitioned
table, the table is automatically partitioned across all the disk volumes on the system.
To create a non-partitioned table using the Neoview Command Interface, specify the
NO PARTITION option with the CREATE TABLE command.
— You cannot create partitioned tables that do not specify a primary key. The primary
key is always the clustering key for the partitioned table.
— If you use the DB Admin CREATE TABLE wizard and provide a maximum table size,
or use a CREATE TABLE statement with a maximum table size clause, the space allocated
for the system is based on the maximum table size.
— If you do not provide a maximum table size in either the DB Admin CREATE TABLE
wizard or in a CREATE TABLE statement, these are the table size defaults:
Partitioned TablesNonpartitioned Tables
Maximum Table
Size
Initial Table SizeMaximum Table
Size
Initial Table SizeTable Creation
Method
76 GB * number of
partitions
100 MB * number of
partitions
76 GB100 MBDB Admin
CREATE TABLE
wizard
150 GB * number of
partitions
100 MB * number of
partitions
150 GB100 MBCREATE TABLE
statement and
scripting
• CREATE INDEX statement
— You can create indexes with DB Admin or with the Neoview Command Interface. DB
Admin builds a CREATE INDEX statement that uses the same partitions as the base
table. If you do not specify the hash partitioning columns, the default is the same
partitioning column or columns as the base table for a non-unique index, and for all
the columns in the index for a unique index. NCI supports the same functionality.
— When you create an index using DB Admin, it automatically uses the NO POPULATE
option, and schedules a POPULATE INDEX operation. With the Neoview Command
Interface, if you are creating an index on an empty table, use the POPULATE option.
For tables that contain data, use the NO POPULATE option and follow that with a
POPULATE INDEX. Currently the POPULATE INDEX command allows you read
access to your table but you cannot update the table while the operation is going on.
For details about data types for your database, see Appendix A (page 117). For details about
character sets for your database, see the Neoview Character Sets Administrator's Guide.
Neoview SQL Table Options
DB Admin allows these Neoview SQL table options:
Guidelines for Database Administrators 31