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 SEPTEMBER 24, 2023

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.