FASTGLOB parameter: Difference between revisions
Jump to navigation
Jump to search
(Automatically generated page update) |
|||
| Line 11: | Line 11: | ||
<dd>All | <dd>All | ||
<dt>Introduced | <dt>Introduced | ||
<dd><var class="product">Model 204 V6.1</var> | <dd><var class="product">Model 204 V6.1</var> | ||
</dl> | </dl> | ||
==Description== | ==Description== | ||
<p>When you set the FASTGLOB parameter to 1, User Language requests can process global lists and found sets more efficiently. A variable containing an NTBL offset that points to the NTBL entry for the list or found set is stored in VTBL. When a global list or found set is referenced via a PLACE RECORDS or FIND statement, NTBL is searched directly using the offset stored in the VTBL entry. (However, it is possible that a sequential scan will still be required if NBTL has been shuffled.) </p> | <p>When you set the FASTGLOB parameter to 1, User Language requests can process global lists and found sets more efficiently. A variable containing an NTBL offset that points to the NTBL entry for the list or found set is stored in VTBL. When a global list or found set is referenced via a PLACE RECORDS or FIND statement, NTBL is searched directly using the offset stored in the VTBL entry. (However, it is possible that a sequential scan will still be required if NBTL has been shuffled.) </p> | ||
Revision as of 13:28, 11 September 2014
Fast global processing
Summary
- Default value
- 0
- Parameter type
- System
- Where set
- Resettable
- Related products
- All
- Introduced
- Model 204 V6.1
Description
When you set the FASTGLOB parameter to 1, User Language requests can process global lists and found sets more efficiently. A variable containing an NTBL offset that points to the NTBL entry for the list or found set is stored in VTBL. When a global list or found set is referenced via a PLACE RECORDS or FIND statement, NTBL is searched directly using the offset stored in the VTBL entry. (However, it is possible that a sequential scan will still be required if NBTL has been shuffled.)
Enabling this feature causes VTBL entries to expand by eight bytes for each global list or found set.
Valid settings of FASTGLOB are:
| Setting | Meaning |
|---|---|
| 0 | FASTGLOB feature is disabled. References to global lists and found sets require sequential scans of NTBL. |
| 1 | FASTGLOB feature is enabled. A variable containing an NBL offset, which is stored in VTBL, points to the NTBL entry for the list or found set. |