Neoview Database Administrator's Guide (R2.5)

3 Guidelines for Database Administrators
This chapter describes some guidelines for managing your database.
Partitioning For Tables and Indexes
• 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 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 a CREATE TABLE statement, these are
the table size defaults:
Partitioned TablesNonpartitioned Tables
Maximum Table SizeInitial Table SizeMaximum Table SizeInitial Table Size
150 GB * number of
partitions
100 MB * number of
partitions
150 GB100 MB
• CREATE INDEX statement
— You create indexes with NCI, using SQL statements. A CREATE INDEX statement 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.
— 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 the Neoview SQL Reference Manual. For details
about character sets for your database, see the Neoview Character Sets Administrator's Guide.
Managing Database Objects
Use HPDM to browse the database, display database objects, and display attributes or statistics
for database objects. For more information, see the HP Database Manager (HPDM) User Guide and
the HPDM online help.
Use NCI to perform SQL commands affecting database objects. For more information, see the
Neoview SQL Reference Manual for the syntax of Neoview SQL commands, and Neoview Command
Interface (NCI) Guide for running commands and scripts.
Use NPAT to analyze queries and monitor system and workload metrics. For more information,
see the Neoview Performance Analysis Tools User Guide and the NPAT Online Help.
Use the Workload Management Service (WMS) to manage the workload and resources on the
Neoview platform. For more information about WMS, refer to the Workload Management Services
User Guide.
To perform maintenance tasks such as scheduling update statistics, see Chapter 5 (page 25).
Partitioning For Tables and Indexes 19