Can We Create Index On Au_parent_obj_ID0 To Improve Performance Of Query Related To AU_BILLINFO_T (Doc ID 1586608.1)

Last updated on NOVEMBER 09, 2015

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 and later
Information in this document applies to any platform.

Goal

Observed that there is a performance bottleneck when there are purchase or cancel operations on product or services on an account with multiple subscriptions. From a closer look on DB side, it showed that the below query is taking longer time. As per analysis by the site DBA, creating an index on AU_BILLINFO_T.au_parent_obj_ID0 would improve performance.

select distinct actg_last_t, actg_next_t, actg_future_t, actg_cycle_dom, created_t, poid_DB, poid_ID0, poid_TYPE, poid_REV
 from au_billinfo_t
 where au_billinfo_t.au_parent_obj_ID0 = :1 order by au_billinfo_t.created_t desc

Question is whether creating such index would impact any functionality in an adverse way.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms