• Depending on the data distribution, search on optional index column will likely to cause time out. See example -

• Select BSEG_​ID

• From CI_​BSEG

• Where MASTER_​BSEG_​ID = &IN.MASTER-BSEG-ID

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