Filter
Top Products
DEFAULT_OBJECT_TABLE_SIZE of the operating environment file. Reserve a sufficient value, taking into
account the amount of data to be handled.
For information about the storage structure, see 2.7 "Defining a Storage Structure."
2.9.3 Index definition
Use the CREATE INDEX statement to define an index.
In the index definition, specify the columns that form the index key and the database space for holding the table data.
SymfoWARE/RDB automatically generates the index DSO and DSI definitions.
Index name
Define the name (index name) to be assigned to the index, using up to 8 alphanumeric characters beginning with an
alphabetic character.
Note that the index name can be specified with character strings of up to 36 alphanumeric characters beginning with
an alphabetic character when DEFAULT_DSI_NAME=CODE is specified in the system operating environment file.
To delete the index definition, specify the index definition to be deleted by index name.
Key specification
Specify the column name of the column that is to be the index key. Multiple columns can be combined to form a single
index.
Storage area specification
After the keyword ON, specify the database space name of the database space for storing the index.
The following example defines the storage structure of an index formed by combining the ITMNO and PRODUCT
columns of the stock management database. The index name is IDX1, and the index is stored in the database space
named DBSPACE1.
Example:
CREATE INDEX statements for defining the STOCK table
The preceding specification has the same meaning as the following definition.
70