My Oracle Support Banner

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

Last updated on JUNE 05, 2018

Applies to:

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

Purpose

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

Scope

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.

EVENT_BAL_IMPACTS_T table:
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.

Details

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
Purpose
Scope
Details

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