SQL statements for managing the storage structure

SQL statement	Function
CREATE STOGROUP	Creates a new storage group
ALTER STOGROUP	Alters a storage group definition
DROP STOGROUP	Deletes a storage group
CREATE SPACE	Creates a space and enters the space name in the metadata
ALTER SPACE	Changes the properties of a space
DROP SPACE	Deletes a user space
CREATE INDEX	Creates an index for a base table
DROP INDEX	Deletes an index
REORG STATISTICS	Rebuilds global statistics for an index

Table 28: SQL statements for managing the storage structure