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
.