Other

Depending on the data distribution, searching on optional index columns is likely to cause time out. For example:

Select BSEG_ID
From CI_BSEG
Where MASTER_BSEG_ID = &IN.MASTER-BSEG-ID

For such cases, consider additional restrictions or recreate the index to become composite - MASTER_​BSEG_​ID + BSEG_​ID.