Filter
Top Products
2.7.3 Index DSO definition
Use the CREATE DSO statement to specify an index DSO definition. If a column is used for a conditional search,
define an index for the column used in the search condition to improve the search efficiency.
If PRIMARY KEY or UNIQUE is specified in a table definition, an index DSO definition with the same column
configuration is required. (The order is the same.) If RANDOM is specified for the table data structure, either
PRIMARY KEY or UNIQUE can be associated with CLUSTER KEY. In this case, an index DSO definition is
unnecessary.
In addition, a new index DSO definition can be added for a table in which data has already been stored.
Sample index DSO definitions follow.
Example:
Index DSO definitions
· When the table data structure is SEQUENTIAL
· When the table data structure is RANDOM
· When the table data structure is OBJECT
55