My Oracle Support Banner

Index Creation On BRM Out-Of-Box Tables (Doc ID 2636871.1)

Last updated on FEBRUARY 14, 2020

Applies to:

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

Goal

When using the opcode PCM_OP_CUST_DELETE_ACCT to delete the data for specific accounts, during the delete, one has observed slow database performance. In this context, will it be ok to create indexes on the following tables so as to enhance the database performance and the overall process execution time?

AU_ACCOUNT_T
AU_ACCOUNT_EXEMPTIONS_T
AU_BAL_GRP_T
AU_PAYINFO_CC_T
AU_PAYINFO_T
AU_PROFILE_WRITEOFF_T
AU_GROUP_T
AU_GROUP_SHARING_MEMBERS_T
AU_ORDERED_GROUPS_T
 

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!


In this Document
Goal
Solution
References


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