SQL statements for managing the storage structure

Storage group

SQL statement	Function
ALTER STOGROUP	Modify a storage group
CREATE STOGROUP	Create a storage group
DROP STOGROUP	Drop a storage group

Table 43: SQL statements for storage groups

Space

SQL statement	Function
ALTER SPACE	Modify space parameter
CREATE SPACE	Create a space
DROP SPACE	Delete a space

Table 44: SQL statements for spaces

Index

SQL statement	Function
CREATE INDEX	Create an index
DROP INDEX	Delete an index
REORG STATISTICS	Re-generate global statistics

Table 45: SQL statements for indexes