MS SQL Server Indexes

The Core 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_ACCESS_OWNER	ACCESS_ACTI_CHRONOLOGY
IX_ACCESS_ACTIVATION	ACCESS_ACTI_CHRONOLOGY
IX_ACTI_CHRO_SUBS	ACCESS_ACTI_CHRONOLOGY
IX_ACTI_CHRO_CACO	ACCESS_ACTI_CHRONOLOGY
IX_ACCESS	ACCESS_TABLE
IX_ACCOUNT_EVENT_RATE_PP	ACCOUNT_EVENT_RATE
IX_CA_MAPPING	ACTI_CHARGING_MAPPING
IX_ACM_ROOT_SUBS_OID	ACTI_CHARGING_MAPPING
IX_CA_DEP_SUBS	ACTI_DEPENDENT
IX_CA_DEPENDENT	ACTI_DEPENDENT
IX_AD_ROOT_SUBS_OID	ACTI_DEPENDENT
IX_AP_ROOT_SUBS_OID	ACTI_PARAMETER
IX_ACPA_ACTI	ACTI_PARAMETER
IX_ACTI_TIERTI_RS_OID	ACTI_TIER_TABLE_INSTANCE
IX_ACTI_TIERTI_ACTI_OID	ACTI_TIER_TABLE_INSTANCE
IX_ACTI_TIERTR_TINS_OID	ACTI_TIER_TABLE_ROW
IX_ACTI_TIERTR_RS_OID	ACTI_TIER_TABLE_ROW
IX_ATI_ROOT_SUBS_OID	ACTI_TRANSLATION_INSTANCE
IX_ACTT_ACTI	ACTI_TRANSLATION_INSTANCE
IX_ACTR_ACTT	ACTI_TRANSLATION_ROW
IX_ATR_ROOT_SUBS_OID	ACTI_TRANSLATION_ROW
IX_AE_CLASS_ID	AE_CLASS
IX_AE_CLASS_SP	AE_CLASS
IX_AE_PROPERTY_DESCRIPTION	AE_PROPERTY_DESCRIPTION
IX_ALLO_ITM	ALLO
IX_AMAL_SUAC	AMOUNT_ALERT
IX_AUDIT_CODE	AUDIT_CYCLE
IX_CACO_ITM	CACI
IX_CACI_AA_CACO	CACI_ACCOUNT_ASSIGNMENT
IX_CACI_IPR_CACO	CACI_PARAMETER
IX_CACI_PCO_CACO	CACI_POOLED_COUNTER
IX_CACI_SCO_CACO	CACI_SHARED_COUNTER
IX_CACI_UTI_CACO	CACI_USER_TECH_ID
IX_CACI_VAL_CACO	CACI_VALIDITY
IX_CACO_SUAC	CACO
IX_CACO_ROCO	CACO
IX_CACO_EXT_ID	CACO
IX_CACO_AI	CACO_ADDITIONAL_INFO
IX_CACO_SCO	CACO_SHARED_COUNTER
IX_CAPA_OWNER	CAPA
IX_CAPA_EXT_ID	CAPA
IX_CAPA_ACAS	CAPA_ACCOUNT_ASSIGNMENT
IX_CAPA_AI	CAPA_ADDITIONAL_INFO
IX_CAPA_CHDE	CAPA_CHARGE_DEPENDENCY
IX_CAPA_CT	CAPA_COUNTER
IX_CAPA_DICT	CAPA_NAMES_DICT
IX_CAPA_PR	CAPA_PARAMETER
IX_UTI_CT	CAPA_USER_TECH_ID
IX_CAPA_ITM	CAPI
IX_CAPA_ACASREF	CAPI_ACCOUNT_ASSIGNMENT_REF
IX_CAPI_CITM_CAPI_OID	CAPI_CHARGED_ITEM_MAPPING
IX_CAPA_CCR	CAPI_CHARGE_COMPONENT_REF
IX_CAPI_CITM_ENTRY	CAPI_CITM_ENTRY
IX_CAPA_ICT	CAPI_COUNTER
IX_CAPA_CREF	CAPI_COUNTER_REF
IX_CAPA_IPR	CAPI_PARAMETER
IX_CAPA_PREF	CAPI_PARAMETER_REF
IX_CAPA_UITREF	CAPI_USER_TECH_ID_REF
IX_CAPP_AI	CAPP_ADDITIONAL_INFO
IX_CATA_CODE	CATALOG_ENTRY
IX_CATA_OWNER	CATALOG_ENTRY
IX_CATA_PARENT	CATALOG_ENTRY
IX_CCCD_CCON	CCON_COUNTER_DESC
IX_CCPA_CCON	CCON_PARAMETER
IX_CCTIERTI_CCON_OID	CCON_TIER_TABLE_INSTANCE
IX_CCTIERTR_TINS_OID	CCON_TIER_TABLE_ROW
IX_CCTI_CCON	CCON_TRANSLATION_INSTANCE
IX_CCTR_CCON	CCON_TRANSLATION_ROW
IX_CHARGED_ITEM_CLASS_OWNER	CHARGED_ITEM_CLASS
IX_CHARGED_ITEM_CLASS_CODE	CHARGED_ITEM_CLASS
IX_CITM_CCON_OID	CHARGED_ITEM_MAPPING
IX_CA_CCON	CHARGE_ACTIVATION
IX_CA_ROOT_SUBS_OID	CHARGE_ACTIVATION
IX_CA_SUBSCRIPTION	CHARGE_ACTIVATION
IX_CA_CODE	CHARGE_ACTIVATION
IX_CC_CODE	CHARGE_COMPONENT
IX_CC_OWNER	CHARGE_COMPONENT
IX_CCOMP_CC_ID	CHARGE_COMP_PRODUCT_CODE
IX_CCOMP_CC_CODE	CHARGE_COMP_PRODUCT_CODE
IX_CCON_CHRG	CHARGE_CONDITION
IX_CCON_OCON	CHARGE_CONDITION
IX_CCON_OFFE	CHARGE_CONDITION
IX_CD_O_OID	CHARGE_DEPENDENCY
IX_CHPD_CHRG	CHARGING_PLAN_DICTIONARY
IX_CIPA_AI	CIPA_ADDITIONAL_INFO
IX_CIPR_AI	CIPR_ADDITIONAL_INFO
IX_CITC_FIELD	CITC_FIELD
IX_CITM_ENTRY	CITM_ENTRY
IX_CIT_AGGR_POLICY_CODE	CIT_AGGR_POLICY
IX_CI_DESCRIPTION	CI_DESCRIPTION
IX_COAC_CACO	COAC
IX_CDES_PLAN	COUNTER_DESC
IX_CLBA_SUAC	CREDIT_LIMIT_BALANCE
IX_CUSTOMER_MANAGEMENT_AREA	CUSTOMER_MANAGEMENT_AREA
IX_DETE_TTEM	DETAIL_TEMPLATE
IX_EIMF_AI	EIMF_ADDITIONAL_INFO
IX_EIM_AI	EIM_ADDITIONAL_INFO
IX_EXAL_SUAC	EXPIRATION_ALERT
IX_EXAC_SUAC	EXTERNAL_ACCOUNT
IX_FILE_SEQUENCES	FILE_SEQUENCES
IX_LOGIN	HCI_USER
IX_CONF_TYPE_NAME	INSTANCE_CONFIGURATION
IX_INSTANCE_ID	INSTANCE_MAP
IX_IN_MACA_COLUMN	IN_MACA_COLUMN
IX_IN_MACRO_PROPERTY	IN_MACRO_PROPERTY
IX_IN_ATTRIBUTE	IN_TABLE_ATTRIBUTE
IX_MACA_AI	MACA_ADDITIONAL_INFO
IX_MARO	MARO
IX_ID_SD_ED_MARO	MARO
IX_MARO_DL_VID	MARO_DL
IX_MAROD_DL_DD	MARO_DL
IX_MATA	MATA
IX_MATA_AI	MATA_ADDITIONAL_INFO
IX_MOPA_OWNER	MOPA
IX_MOPA_EXT_ID	MOPA
IX_MOPA_AI	MOPA_ADDITIONAL_INFO
IX_MOPA_PR	MOPA_PARAMETER
IX_CM_MP	MOPA_SPENDING_STATUS_MAPPING
IX_UTI_MP	MOPA_USER_TECH_ID
IX_MOPP_AI	MOPP_ADDITIONAL_INFO
IX_NBR_RPT_CDT_POLICY	NRCT
IX_OBJ_CHGLG_OID	OBJECT_CHANGE_LOG
IX_OBJ_CHGLG_OPOID	OBJECT_CHANGE_LOG
IX_OBJ_CHGLG_OPDATE	OBJECT_CHANGE_LOG
IX_OCN_VERSION_ID	OBJECT_CHANGE_NUMBER
IX_OCN_OID	OBJECT_CHANGE_NUMBER
IX_OBJ_SNPSH_OID	OBJECT_SNAPSHOT
IX_OCCD_OCON	OCON_COUNTER_DESC
IX_OCPA_OCON	OCON_PARAMETER
IX_OCTIERTI_OCON_OID	OCON_TIER_TABLE_INSTANCE
IX_OCTIERTR_TINS_OID	OCON_TIER_TABLE_ROW
IX_OCTI_OCON	OCON_TRANSLATION_INSTANCE
IX_OCTR_OCTI	OCON_TRANSLATION_ROW
IX_OFFER_OWNER	OFFER
IX_OFFER_CODE	OFFER
IX_OFFER_AI	OFFER_ADDITIONAL_INFO
IX_CKEY_OFFE	OFFER_CDES_KEY
IX_OFFER_CONDITION_OFFER	OFFER_CONDITION
IX_OCON_OFFE	OFFER_CONDITION
IX_OCDE_OFFE	OFFER_COUNTER_DESC
IX_OPAR_OFFE	OFFER_PARAMETER
IX_PKEY_OFFE	OFFER_PARA_KEY
IX_OTIERTI_OFFE_OID	OFFER_TIER_TABLE_INSTANCE
IX_OTIERTR_TINS_OID	OFFER_TIER_TABLE_ROW
IX_OTIN_OFFE	OFFER_TRANSLATION_INSTANCE
IX_OTRO_OTIN	OFFER_TRANSLATION_ROW
IX_ONE_SHOT_RATE_PP	ONE_SHOT_RATE
IX_OUT_MACA_COLUMN	OUT_MACA_COLUMN
IX_OUT_MACRO_PROPERTY	OUT_MACRO_PROPERTY
IX_OUT_RACA_COLUMN	OUT_RACA_COLUMN
IX_OUT_ATTRIBUTE	OUT_TABLE_ATTRIBUTE
IX_PP_PARAMETER	PARAMETER
IX_ACCESS_PPACC	PPACC_ACTI_CHRONOLOGY
IX_ACCESS_PPACCACTIVATION	PPACC_ACTI_CHRONOLOGY
IX_PPACC_ACTI_CHRO_CACO	PPACC_ACTI_CHRONOLOGY
IX_PRAC_SUAC	PREPAID_ACCOUNT
IX_PPTM_CCON	PREPAID_TRANSAC_MAPPING
IX_PP_CHRG	PRICE_PLAN
IX_PP_FREETEXT	PRICE_PLAN_FREE_TEXT
IX_PRICING_MACRO_OWNER	PRICING_MACRO
IX_PRICING_MACRO_CODE	PRICING_MACRO
IX_PRODUCT_VENDOR	PRODUCT
IX_PRODUCT_CODE	PRODUCT
IX_PROPERTY_DESCRIPTION	PROPERTY_DESCRIPTION
IX_RACA_AI	RACA_ADDITIONAL_INFO
IX_RARO	RARO
IX_RATA	RATA
IX_RATA_AI	RATA_ADDITIONAL_INFO
IX_RCOM_RCOM	RATE_COMPONENT
IX_RCOM_RCOH	RATE_COMPONENT
IX_RCOH_OSRA	RATE_COMPONENT_HOLDER
IX_RCOH_RERA	RATE_COMPONENT_HOLDER
IX_RCOH_USRA	RATE_COMPONENT_HOLDER
IX_RCOH_MACR	RATE_COMPONENT_HOLDER
IX_RCOH_AERA	RATE_COMPONENT_HOLDER
IX_RCOH_EVRA	RATE_COMPONENT_HOLDER
IX_RCOP_RCOM	RATE_COMPONENT_PROPERTY
IXK_RATING_RECORD	RATING_RECORD
IX_RR_RESERVATION	RATING_RECORD
IX_RR_SUBSCRIPTION	RATING_RECORD
IX_RPRT_CDT_SET_POLICY	RCST
IX_RECURRING_RATE_PP	RECURRING_RATE
IX_RI_CLASS_ID	RI_CLASS
IX_RI_CLASS_SP	RI_CLASS
IX_RI_PROPERTY_DESCRIPTION	RI_PROPERTY_DESCRIPTION
IX_COUNTER_MODIFICATION_RR	RR_COUNTER_MODIFICATION
IX_PROPERTY_RR	RR_PROPERTY
IX_SSD_ID	SPENDING_STATUS_DESC
IX_SSM_CACO_OID	SPENDING_STATUS_MONITORING
IX_SSM_MONITORING_ID	SPENDING_STATUS_MONITORING
IX_SSM_EXPIRATION_DATE	SPENDING_STATUS_MONITORING
IX_SSD_LABEL	SSD_LABEL
IX_SUAI_SUAC	SUAC_ADDITIONAL_INFO
IX_SUAC_CODE	SUBSCRIBER_ACCOUNT
IX_SUAC_OID	SUBSCRIBER_ACCOUNT
IX_SUB_OFFE	SUBSCRIPTION
IX_SUB_SUBID	SUBSCRIPTION
IX_S_ROOT_SUBS_OID	SUBSCRIPTION
IX_SUBS_OCOD	SUBSCRIPTION
IX_SUBS_SUAC	SUBSCRIPTION
IX_SUBS_SUAC_G	SUBSCRIPTION
IX_SUB_CODE	SUBSCRIPTION
IX_SAI_ROOT_SUBS_OID	SUBS_ADDITIONAL_INFO
IX_SUB_ADDITIONAL_INFO	SUBS_ADDITIONAL_INFO
IX_SUB_PARA	SUBS_PARAMETER
IX_SP_ROOT_SUBS_OID	SUBS_PARAMETER
IX_STIERTI_SUBS_OID	SUBS_TIER_TABLE_INSTANCE
IX_STIERTI_RS_OID	SUBS_TIER_TABLE_INSTANCE
IX_STIERTR_TINS_OID	SUBS_TIER_TABLE_ROW
IX_STIERTR_RS_OID	SUBS_TIER_TABLE_ROW
IX_SUB_TINS	SUBS_TRANSLATION_INSTANCE
IX_STI_ROOT_SUBS_OID	SUBS_TRANSLATION_INSTANCE
IX_SUBS_TRANSLATION_ROW	SUBS_TRANSLATION_ROW
IX_STR_ROOT_SUBS_OID	SUBS_TRANSLATION_ROW
IX_SUMT_MACA	SUMT
IX_SUMT_SUAC	SUMT
IX_SUMT_ID	SUMT
IX_SUMT_AI	SUMT_ADDITIONAL_INFO
IX_SUMT_MARO	SUMT_MARO
IX_SURT_RACA	SURT
IX_SURT_SUAC	SURT
IX_SURT_ID	SURT
IX_SURT_AI	SURT_ADDITIONAL_INFO
IX_SURT_RARO	SURT_RARO
IX_TXPS_CCON	TAX_PARAMETER_SET
IX_TIERT_OWNER	TIER_TABLE
IX_TIERT_CODE	TIER_TABLE
IX_TIERTI_TTAB_OID	TIER_TABLE_INSTANCE
IX_TIERTI_TTAB_CODE	TIER_TABLE_INSTANCE
IX_TIERTOA_TTAB_OID	TIER_TABLE_OUT_ATTRIBUTE
IX_TIERTR_TINS_OID	TIER_TABLE_ROW
IX_TTEM_CCON	TRANSAC_TEMPLATE_DESC
IX_TI_TTAB	TRANSLATION_INSTANCE
IX_TRANSLATION_INSTANCE_CODE	TRANSLATION_INSTANCE
IX_TRANSLATION_ROW	TRANSLATION_ROW
IX_TT_OWNER	TRANSLATION_TABLE
IX_TT_CODE	TRANSLATION_TABLE
IX_USAGE_RATE_PP	USAGE_RATE
IX_UA_ID	USER_AUTH
IX_FAILED_AUTH	USER_FAILED_AUTHENTICATION
IX_UOP_OPDATE	USER_OPERATION
IX_UOP_OPNAME	USER_OPERATION
IX_OP_FILTER_AUDIT	USER_OPERATION_FILTER
IX_PASSWORD	USER_PASSWORD
IX_USER	USER_RIGHT
IX_UR_ID	USER_ROLE
IX_WS_IDPY	WS_IDEMPOTENCY

Additional Information

Implementation Project Phase

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

Production Operation Phase

Rebuilding Indexes

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