Fujitsu server 5.0L10 Manual

PDF-manualer
225 Sidor Engelska

Fujitsu server 5.0L10
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
Innehållsförteckning
Expandera alla
Relaterade manualer för Fujitsu server 5.0L10
B120
Fujitsu server B120

För server (68 Sidor)
BX400 S1
Fujitsu server BX400 S1

För server (130 Sidor)
2000
Fujitsu server 2000

För server (162 Sidor)
2000 SERIES
Fujitsu server 2000 SERIES

För server (285 Sidor)
T2000
Fujitsu server T2000

För server (28 Sidor)
M5000
Fujitsu server M5000

För server (50 Sidor)
M8000
Fujitsu server M8000

För server (110 Sidor)
TX200FT S2
Fujitsu server TX200FT S2

För server (12 Sidor)
V4.90
Fujitsu server V4.90

För server (62 Sidor)
RXI300
Fujitsu server RXI300

För server (10 Sidor)
T5120
Fujitsu server T5120

För server (12 Sidor)
RX330
Fujitsu server RX330

För server (94 Sidor)
M3000
Fujitsu server M3000

För server (8 Sidor)
M8000
Fujitsu server M8000

För server (144 Sidor)
M8000/M9000
Fujitsu server M8000/M9000

För server (4 Sidor)