 |
» |
|
|
|
The SYSTEM.SETOPTINFO view displays the access optimization
plan of a section as specified by the SETOPT statement.
The information is stored in a series of segments of up to 64 bytes.
The access plan in SYSTEM.SETOPTINFO is used by the section
if the OPTFLAG column of SYSTEM.SECTION is set to 1.
SYSTEM.SETOPTINFO is initially empty, and it is updated whenever
ALLBASE/SQL processes a SETOPT statement. Table 8-31 System.Setoptinfo | Column Name | Type | Length | Description |
|---|
| NAME | CHAR | 20 | Name of the section | | OWNER | CHAR | 20 | Owner of the section | | SECTION | INTEGER | 4 | Section number | | TYPE | INTEGER | 2 | Type of section: - 0
for module section - 1
for procedure section
| | SEGNUM | INTEGER | 4 | Segment number | | SEGLEN | INTEGER | 4 | Segment length (Up to 64) | | SETOPTSTRING | CHAR | 64 | SETOPT byte string segment |
EXAMPLE | |
SELECT * FROM System.Setoptinfo;
--------------------+--------------------+-----------+-----------+
NAME |OWNER |SECTION |TYPE |
--------------------+--------------------+-----------+-----------+
CEX9 |PROGM1 | 1| 0|
CEX9 |PROGM1 | 2| 0|
CEX9 |PROGM1 | 3| 0|
CEX9 |PROGM1 | 4| 0|
CEX9 |PROGM1 | 5| 0|
CEX9 |PROGM1 | 6| 0|
First 6 rows have been selected.
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>,or e[nd]> r
-----------+-----------+-------------------------
SEGNUM |SEGLEN |SETOPTSTRING
-----------+-----------+-------------------------
1| 25|setopt general indexscan;
1| 25|setopt general indexscan;
1| 25|setopt general indexscan;
1| 25|setopt general indexscan;
1| 25|setopt general indexscan;
1| 25|setopt general indexscan;
---------------------------------------------------------------------------
Number of rows selected is 6
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>,or e[nd]> e
|
|
