INDEX NEEDED ON CI_BCHG_UP ON COLUMN SA_EXT_REF_ID
(Doc ID 2265597.1)
Last updated on JULY 18, 2019
Applies to:Oracle Utilities Customer Care and Billing - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
**Examples provided in this article do not represent real life personal/confidential information**
**Disclaimer:** This KM article may include the following abbreviations:
CCB - Oracle Utilities Customer Care and Billing
SP - Service Pack
a full table scan is done on CI_BCHG_UP because in
the 2nd part of the sql, we have this:
FROM CI_BCHG_UP BCU
WHERE BCU.SA_EXT_REF_ID BETWEEN :4 AND :5 << need index on sa_ext_ref_id
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document