MS SQL Server Indexes

The BART Database of SAP Convergent Charging includes the following database indexes to speed up the retrieval of data stored in the database tables.

Caution

Do not create another index in your database system.

During the production operation phase, consult first your SAP Support Team. During the project implementation phase, refer to your project team and consultants.

Technical Operations and Maintenance

Recommendation

SAP recommends that you manage the existing indexes by rebuilding them on a regular basis or when necessary. Your data base administrator (DBA) defines the relevant rebuild policy.

Consult the SAP CC Operations Guide documentation for more information.

Index List

Index	Table
IX_ACQUISITION_SESSION	ACQUISITION_SESSION
IX_MAGIC_NUMBER	CDR
IX_SUBS_CDR	CDR
IX_CDR_OID	CDR
IX_CDR_SE	CDR
IX_STATUS	CDR
IX_COLLECTION	COLLECTION
IX_RATING_SESSION	RATING_SESSION
IX_RERATING_SESSION_ORDER	RERATING_SESSION_ORDER

Additional Information

Implementation Project Phase

Refer to the SAP CC Tuning Guide for more information about the hardware sizing with SAP Convergent Charging.
Refer to the SAP CC Installation and Maintenance Guide for more information about the installation preparations.

Production Operation Phase

Rebuilding Indexes

Refer to the SAP CC Administration Guide for more information about the database monitoring, maintenance, or purging and archiving operations.