Oracle optimization
This parameter is useful only if the parameter ORAOPTMIZ is set to Yes and is only useful for the Oracle database.
In this case, an optimization strategy FIRST ROWS is used for the left lists; then this parameter can be used to specify a number of lines to be searched as fast as possible in order to improve even more the optimization of searching times.
Level of localization/Global variable
This parameter is defined at the level Folder. It belongs to Chapter SUP (Supervisor) and the Group PRF (Performances), The following parameters are also associated with this chapter and group :
- AUZMEMO (Create all memos)
- CLOMAX (Max no.)
- LAUNCHSYNC (Sync launch after patch integration)
- MAXSPEACV (Specific ACV limit)
- MAXUPDTRS (Update transaction limit)
- MEMTXT (Size of text memory)
- NBTRABUFF (Number of lines in memory)
- NXTREC (Threshold for last read access)
- ORAOPTMIZ (Oracle optimization)
- ORATRAPATH (Oracle optimization)
- ROLLBACK (Lock attempts before rollback)
- SELWARN (Limit for control memos)
- TIMLCK (Unlock time in seconds)
- TIMOUT (Time limit for response)
The global variable GORAOPTNB is associated with it.
Comments
The value specified for this parameter is similar to the values indicated by the parameters LFTBOX, NBRCHOOSE and NBDERLUS (which are defined more accurately by the user).
Even if it is equal to 0, the optimization is still substantial as long as the parameter ORAOPTMIZ is set to Yes; It is a very acute optimization.