My Oracle Support Banner

Suggestion On Modifying The Out Of Box Index(es) To Improve Performance (Doc ID 1205564.1)

Last updated on DECEMBER 05, 2019

Applies to:

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


Can one modify the existing OOB indexes to improve BRM performance ?


In a customer setup, one has modified indexes as follows :

ITEM_T table:
add the column (EFFECTIVE_T) into the existing index I_ITEM_AR_BNFO_OBJ_ID_EFFEC.

add the columns (RESOURCE_ID, AMOUNT_DEFERRED) into the existing index I_EVENT_BI_ITEM_OBJ__ID.

During a performance test, the changes mentioned above significantly improved the performance of the billing process.

One may want to understand if such changes to indexes can be made in every BRM setup. Below feedback might serve as a reference in this context.


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

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