Server User Manual

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)