Filter
Top Products
Index storage structure
The index storage structure is as follows:
Storage structure:
BTREE structure
Data part page size:
2 kilobytes
Index part page size:
2 kilobytes
Data part allocation size:
168 kilobytes
Degeneration specification:
Present
Index part allocation size:
32 kilobytes
Index comment definition
A comment consisting of a character string can be specified for an index if the index is defined with an abbreviated
storage structure definition. A character string of up to 256 bytes can be specified. If no comment is necessary, omit
the specification. An example follows.
Example:
Specifying a comment for an index that has an abbreviated storage structure definition.
2.10 Defining a Temporary Table
Before using a temporary table, define the temporary table and an index.
A temporary table is created specifically for a user of an application program. Multiple users can use temporary tables
with the same table name. Uses of temporary tables are listed below.
· Extracting data necessary for a user from a database and creating a table containing the data
· Incorporating processing results of a procedure routine into an application program using a temporary table
As described above, a temporary table can be used as a table independent of other application programs to facilitate
development of an application program.
Extracting data necessary for a user from a database and creating a table containing the dat
a
When data manipulated by a user can be limited or if specific data is frequently referenced, creating in advance a
compact table containing necessary data enables smooth processing that is not affected by update operations of
another user.
Temporary tables can be used for such processing. To create a compact table, data can be extracted from the master
table (STOCK table) according to the conditions set for a user and then stored in a temporary table (T1).
72