A_SYB_FORCED_INDEX configuration variable

A_SYB_FORCED_INDEX causes the Acu4GL product to attempt to use an actual index that matches the key used with the table. For this variable to have any effect, the index matching the key must be a unique index.

While the default value is 0 (OFF, FALSE, NO), this configuration variable can also take the value of YES (ON, TRUE). If you don’t use the forced-index feature, the Acu4GL product adds an ORDER BY clause to the SELECT, which can add to processing time.

Sybase does not guarantee that an index is used if this variable is set to 1, so the order of records returned to the COBOL program is not guaranteed to be correct in that case. Because of this, it is recommended this variable not be set to setting this variable to 0 (OFF, FALSE, NO).