BATCHEDREAD_INDEX configuration parameter

Use the BATCHEDREAD_INDEX configuration parameter to enable the optimizer to execute light scans for indexes. This reduces the number of times that a buffer is read, thus improving performance.

onconfig.std value
BATCHEDREAD_INDEX 1
values
0 = Disable light scans for indexes.

1 = Enable light scans for indexes.

takes effect
After you edit your onconfig file and restart the database server.
When you reset the value dynamically in your onconfig file by running the onmode -wf command.
When you reset the value in memory by running the onmode -wm command.

In sessions where the IFX_BATCHEDREAD_INDEX configuration parameter and the IFX_BATCHEDREAD_INDEX session environment variable have different settings, the session environment variable takes precedence for the duration of that session, or until the IFX_BATCHEDREAD_INDEX session environment variable is reset.


Copyright© 2019 HCL Technologies Limited