Filter
Top Products
BTREE
For PAGESIZE1, specify the page size of the data part.
For PAGESIZE2, specify the page size of the index part.
For details, refer to "4.2.1 BTREE Structure."
Base representation
Specify the way the index and base are associated. If this specification is omitted, SEQUENTIAL or OBJECT default
to ADDRESS , and RANDOM defaults to KEY.
ADDRESS:
The index and table records are associated according to the storage addresses of the table records. Specify
ADDRESS when the table data structure is SEQUENTIAL or OBJECT.
KEY:
The index and table records are associated according to the cluster key of the table records. Specify KEY
when the table data structure is RANDOM.
2.7.4 Table DSI definition
Use the CREATE DSI statement to specify a table DSI definition. The table DSI definition allocates database space
according to the table DSO definition.
Sample table DSI definitions follow.
Example:
Table DSI definitions
· When split table operation is not applied (data structure: SEQUENTIAL)
· When split table operation is not applied (data structure: RANDOM)
· When split table operation is applied (data structure: SEQUENTIAL)
57