MS SQL Server Indexes


The Cockpit 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_ALLOWANCE_PLAN_NAME ALLOWANCE_PLAN
IX_ALLOWANCE_PLAN_STATE ALLOWANCE_PLAN
IX_ALLOWANCE_PLAN_CATALOG ALLOWANCE_PLAN
IX_ALLOWANCE_PLAN_CHARGED_ITEM_DEFINITION_NAME ALLOWANCE_PLAN_CHARGED_ITEM_DEFINITION
IX_ALLOWANCE_PLAN_CHARGED_ITEM_DEFINITION_STATE ALLOWANCE_PLAN_CHARGED_ITEM_DEFINITION
IX_ALLOWANCE_PLAN_CHARGED_ITEM_DEFINITION_FIELD_NAME ALLOWANCE_PLAN_CHARGED_ITEM_DEFINITION_FIELD
IX_ALLOWANCE_PLAN_CHARGED_ITEM_DEFINITION_FIELD_STATE ALLOWANCE_PLAN_CHARGED_ITEM_DEFINITION_FIELD
IX_CATALOG_NAME CATALOG
IX_CHARGEABLE_ITEM_CLASS_NAME CHARGEABLE_ITEM_CLASS
IX_CHARGEABLE_ITEM_CLASS_STATE CHARGEABLE_ITEM_CLASS
IX_CHARGEABLE_ITEM_CLASS_CONSUMPTION_ITEM_CLASS_NAME CHARGEABLE_ITEM_CLASS
IX_CHARGED_ITEM_CLASS_NAME CHARGED_ITEM_CLASS
IX_CHARGED_ITEM_CLASS_STATE CHARGED_ITEM_CLASS
IX_CHARGED_ITEM_CLASS_CATALOG CHARGED_ITEM_CLASS
IX_CHARGED_ITEM_CLASS_BILLABLE_ITEM_CLASS_NAME CHARGED_ITEM_CLASS
IX_CHARGED_ITEM_DEFINITION_NAME CHARGED_ITEM_DEFINITION
IX_CHARGED_ITEM_DEFINITION_STATE CHARGED_ITEM_DEFINITION
IX_CHARGED_ITEM_DEFINITION_FIELD_NAME CHARGED_ITEM_DEFINITION_FIELD
IX_CHARGED_ITEM_DEFINITION_FIELD_STATE CHARGED_ITEM_DEFINITION_FIELD
IX_CONTEXT_PROPERTY_FCO CONTEXT_PROPERTY
IX_CONTEXT_PROPERTY_FCO_CPO CONTEXT_PROPERTY
IX_CONTEXT_PROPERTY_C_C_T_K CONTEXT_PROPERTY
IX_CONTEXT_PROPERTY_K_C_T_C_CPO_FCO CONTEXT_PROPERTY
IX_CURRENCY_NAME CURRENCY
IX_CURRENCY_CODE CURRENCY
IX_MAPPING_TABLE_NAME MAPPING_TABLE
IX_MAPPING_TABLE_STATE MAPPING_TABLE
IX_MAPPING_TABLE_CATALOG MAPPING_TABLE
IX_MAPPING_TABLE_MAPPING_TABLE_CLASS_NAME MAPPING_TABLE
IX_MAPPING_TABLE_AGREEMENT_ID MAPPING_TABLE
IX_MAPPING_TABLE_ADDITIONAL_INFO_STATE MAPPING_TABLE_ADDITIONAL_INFO
IX_MAPPING_TABLE_CLASS_NAME MAPPING_TABLE_CLASS
IX_MAPPING_TABLE_CLASS_STATE MAPPING_TABLE_CLASS
IX_MAPPING_TABLE_CLASS_ADDITIONAL_INFO_STATE MAPPING_TABLE_CLASS_ADDITIONAL_INFO
IX_MAPPING_TABLE_CLASS_IN_COLUMN_STATE MAPPING_TABLE_CLASS_IN_COLUMN
IX_MAPPING_TABLE_CLASS_OUT_COLUMN_STATE MAPPING_TABLE_CLASS_OUT_COLUMN
IX_MAPPING_TABLE_ROW_MO MAPPING_TABLE_ROW
IX_MAPPING_TABLE_ROW_MI MAPPING_TABLE_ROW
IX_MAPPING_TABLE_ROW_MSEO MAPPING_TABLE_ROW
IX_MAPPING_TABLE_ROW_MMSO MAPPING_TABLE_ROW
IX_MAPPING_TABLE_ROW_MESIMS MAPPING_TABLE_ROW
IX_MAPPING_TABLE_ROW_MSIMS MAPPING_TABLE_ROW
IX_MAPPING_TABLE_ROW_MMSSO MAPPING_TABLE_ROW
IX_MAPPING_TABLE_ROW_MIMSIO MAPPING_TABLE_ROW
IX_MAPPING_TABLE_ROW_MISO MAPPING_TABLE_ROW
IX_NODE_FTO NODE
IX_NODE_FPO NODE
IX_NODE_FPO_FMO NODE
IX_NODE_FTO_FCO_NO NODE
IX_PRICING_FUNCTION_NAME PRICING_FUNCTION
IX_PRICING_FUNCTION_STATE PRICING_FUNCTION
IX_PRICING_FUNCTION_CATALOG PRICING_FUNCTION
IX_RANGE_TABLE_NAME RANGE_TABLE
IX_RANGE_TABLE_STATE RANGE_TABLE
IX_RANGE_TABLE_CATALOG RANGE_TABLE
IX_RANGE_TABLE_RANGE_TABLE_CLASS_NAME RANGE_TABLE
IX_RANGE_TABLE_AGREEMENT_ID RANGE_TABLE
IX_RANGE_TABLE_ADDITIONAL_INFO_RELEASED_OID RANGE_TABLE_ADDITIONAL_INFO
IX_RANGE_TABLE_ADDITIONAL_INFO_STATE RANGE_TABLE_ADDITIONAL_INFO
IX_RANGE_TABLE_CLASS_NAME RANGE_TABLE_CLASS
IX_RANGE_TABLE_CLASS_STATE RANGE_TABLE_CLASS
IX_RANGE_TABLE_RANGE_RELEASED_OID RANGE_TABLE_RANGE
IX_RANGE_TABLE_RANGE_STATE RANGE_TABLE_RANGE
IX_RANGE_TABLE_RANGE_SET_KEY_RELEASED_OID RANGE_TABLE_RANGE_SET_KEY
IX_RANGE_TABLE_RANGE_SET_KEY_STATE RANGE_TABLE_RANGE_SET_KEY
IX_RANGE_TABLE_VERSION_RELEASED_OID RANGE_TABLE_VERSION
IX_RANGE_TABLE_VERSION_STATE RANGE_TABLE_VERSION
IX_RATE_PLAN_NAME RATE_PLAN
IX_RATE_PLAN_STATE RATE_PLAN
IX_RATE_PLAN_CATALOG RATE_PLAN
IX_RATE_PLAN_ADDITIONAL_INFO_RELEASED_OID RATE_PLAN_ADDITIONAL_INFO
IX_RATE_PLAN_ADDITIONAL_INFO_STATE RATE_PLAN_ADDITIONAL_INFO
IX_RATE_PLAN_CHARGE_RELEASED_OID RATE_PLAN_CHARGE
IX_RATE_PLAN_CHARGE_STATE RATE_PLAN_CHARGE
IX_RATE_PLAN_COUNTER_RELEASED_OID RATE_PLAN_COUNTER
IX_RATE_PLAN_COUNTER_STATE RATE_PLAN_COUNTER
IX_RATE_PLAN_PARAMETER_RELEASED_OID RATE_PLAN_PARAMETER
IX_RATE_PLAN_PARAMETER_STATE RATE_PLAN_PARAMETER
IX_RATE_PLAN_USER_TECHNICAL_IDENTIFIER_RELEASED_OID RATE_PLAN_USER_TECHNICAL_IDENTIFIER
IX_RATE_PLAN_USER_TECHNICAL_IDENTIFIER_STATE RATE_PLAN_USER_TECHNICAL_IDENTIFIER
IX_SPRING_SESSION SPRING_SESSION
IX_SPRING_SESSION_EXPIRY_TIME SPRING_SESSION
IX_SPRING_SESSION_PRINCIPAL_NAME SPRING_SESSION
IX_SPRING_SESSION_ATTRIBUTES SPRING_SESSION_ATTRIBUTES
IX_TREE_CATALOG_OBJECT_OID TREE
IX_TREE_DEBUG_DATA_TO_SI TREE_DEBUG_DATA

Additional Information

Implementation Project Phase

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.