Other
• 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.
Parent topic