Kbase P25892: What is the -v6q parameter used for?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/19/2009 |
|
Status: Verified
GOAL:
What is the -v6q parameter used for?
FACT(s) (Environment):
Progress 7.x
Progress 8.X
Progress 9.X
OpenEdge 10.x
All Supported Operating Systems
FIX:
If you specify the version 6 query parameter (-v6q), the Progress database server uses only a single index when resolving a FOR EACH statement. If you do not use this parameter, the server may use more than one index. Using more than one index is more efficient, however, it might change the order in which the records are returned. Additionally, the -v6q parameter also causes cursor repositioning with FOR EACH statements, as it originally did in version 6.
For more information pertaining to the -v6q parameter, refer to the following Progress Knowledge Center article:
Progress Solution 17490 - The Performance Gains and Caveats of the -v6q Option