My Oracle Support Banner

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 AUGUST 08, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.