Info Mart Indexes

This page provides a comprehensive list of indexes created in a nonpartitioned database, for those tables described in this document. Certain indexes, such as those required for purging, are not created in the schema during database initialization because they are not applicable to a partitioned database. Thus, the number of indexes would be smaller in a partitioned database, where purging is based on partitions.

Legend: U = Unique

Table	Index	U	Description
Table	Index	U	Description
AGENT_LOCATION	I_AGENTLOC_LOCATION	X	Ensures that the combinations of values that are stored in the dimension table are unique.
BGS_BOT_DIM	I_BGS_BOT_DIM	X	Ensures that the combinations of values that are stored in the dimension table are unique.
BGS_BOT_NAME_DIM	I_BGS_BOT_NAME_DIM	X	Ensures that the combinations of values that are stored in the dimension table are unique.
BGS_SESSION_DIM	I_BGS_SESSION_DIM	X	Ensures that the combinations of values that are stored in the dimension table are unique.
BGS_SESSION_FACT	I_BGS_SESSION_FACT_SDT		Improves access time, based on the Start Date Time key.
BOT_ATTRIBUTES	I_BOT_ATTRIBUTES	X	Ensures that the combinations of values that are stored in the dimension table are unique.
BOT_INTENT	I_BOT_INTENT	X	Ensures that the combinations of values that are stored in the dimension table are unique.
CALLBACK_DIAL_RESULTS	I_CALLBACK_DIAL_RESULTS	X	Ensures that the combinations of values that are stored in the dimension table are unique.
CALLBACK_DIM_1	I_CALLBACK_DIM_1	X	Ensures that the combinations of values that are stored in the dimension table are unique.
CALLBACK_DIM_2	I_CALLBACK_DIM_2	X	Ensures that the combinations of values that are stored in the dimension table are unique.
CALLBACK_DIM_3	I_CALLBACK_DIM_3	X	Ensures that the combinations of values that are stored in the dimension table are unique.
CALLBACK_DIM_4	I_CALLBACK_DIM_4	X	Ensures that the combinations of values that are stored in the dimension table are unique.
CALLING_LIST_METRIC_FACT	I_CLMF_SDT		Improves access time, based on the Start Date Time key.
CALLING_LIST_METRIC_FACT	I_CLMF_TNT		Improves access time, based on the Tenant.
CAMPAIGN_GROUP_SESSION_FACT	I_CGSEF_SID	X	Ensures that the facts that are stored in the table are for unique sessions.
CAMPAIGN_GROUP_SESSION_FACT	I_CGSEF_DT		Improves access time, based on the Start Date Time key.
CAMPAIGN_GROUP_SESSION_FACT	I_CGSEF_TNT		Improves access time, based on the Tenant.
CAMPAIGN_GROUP_STATE_FACT	I_CGSTF_STD		Improves access time, based on the Start Date Time key.
CAMPAIGN_GROUP_STATE_FACT	I_CGSTF_CGSF		Improves access time, based on the Campaign Group Session Fact key.
CAMPAIGN_GROUP_STATE_FACT	I_CGSTF_TNT		Improves access time, based on the Tenant.
CDR_DIM1	I_CDR_DIM1	X	Reserved for future use.
CDR_FACT	I_CDR_FACT_SDT		Reserved for future use.
CHAT_SESSION_DIM	I_CHAT_SESSION_DIM	X	Ensures that the combinations of values that are stored in the dimension table are unique.
CHAT_SESSION_FACT	I_CHAT_SESSION_FACT_SDT		Improves access time, based on the Start Date Time key.
CHAT_THREAD_FACT	I_CHAT_THREAD_FACT_SDT		Improves access time, based on the Start Date Time key.
COBROWSE_END_REASON	I_COBROWSE_END_REASON	X	Ensures that the combinations of values that are stored in the dimension table are unique.
COBROWSE_FACT	I_COBROWSE_FACT_SDT		Improves access time, based on the Start Date Time key.
COBROWSE_MODE	I_COBROWSE_MODE	X	Ensures that the combinations of values that are stored in the dimension table are unique.
COBROWSE_PAGE	I_COBROWSE_PAGE	X	Ensures that the combinations of values that are stored in the dimension table are unique.
COBROWSE_USER_AGENT	I_COBROWSE_USER_AGENT	X	Ensures that the combinations of values that are stored in the dimension table are unique.
CONTACT_ATTEMPT_FACT	I_CAF_SDT		Improves access time, based on the Start Date Time key.
CONTACT_ATTEMPT_FACT	I_CAF_TNT		Improves access time, based on the Tenant.
CONTACT_ATTEMPT_FACT	I_CAF_CGSF		Improves access time, based on the Campaign Group Session Fact key.
CONTACT_ATTEMPT_FACT	I_CAF_CID		Improves access time, based on the Call ID.
CTL_AUDIT_LOG	IDX_CTL_AL_CTS		Improves purge performance.
CTL_ETL_HISTORY	I_C_ETL_H_CTS		Improves purge performance.
CTL_EXTRACT_HISTORY	I_C_EXTRACT_H_CTS		Improves purge performance.
CTL_GDPR_HISTORY	I_CTL_GDPR_H_C_ID		Improves search performance.
CTL_GDPR_HISTORY	I_CTL_GDPR_H_CTS		Improves purge performance.
CTL_PURGE_HISTORY	I_C_PURGE_H_CTS		Improves purge performance.
CTL_TRANSFORM_HISTORY	I_C_TRANSFORM_H_CTS		Improves purge performance.
CTL_UDE_KEYS_TO_DIM_MAPPING	I_UDE_KEYS_TO_D_M_KN	X	A constraint that enforces unique mapping for each user-data dimension table.
CTL_UD_TO_UDE_MAPPING	I_C_UD_TARGET	X	A constraint that enforces unique mapping for each column in each target user-data table.
CTL_UD_TO_UDE_MAPPING	I_C_UD_TO_UDE_KN		Improves access time, based on the user-data key name for mapping that is currently active.
DATE_TIME	IDX_DT_30		Improves access time, based on a 30-minute key.
DATE_TIME	IDX_DT_NEXT30		Improves access time, based on the next 30-minute key.
DATE_TIME	IDX_DT_NEXT		Improves access time, based on the key of the next record.
DATE_TIME	IDX_DT_30_INT		Improves access time, based on the 30-minute key, the next 30-minute key, and the primary key.
DATE_TIME	IDX_DT_HOUR_INT		Improves access time, based on the hour key, the next hour key, and the primary key.
DATE_TIME	IDX_DT_DAY_INT		Improves access time, based on the day key, the next day key, and the primary key.
DATE_TIME	IDX_DT_MONTH_INT		Improves access time, based on the month key, the next month key, and the primary key.
DATE_TIME	IDX_DT_CAL_DATE		Improves access time, based on the calendar date.
GPM_DIM1	I_GPM_DIM1	X	Ensures that the combinations of values that are stored in the dimension table are unique.
GPM_FACT	I_GPM_FACT_SDT		Improves access time, based on the Start Date Time key.
GPM_MODEL	I_GPM_MODEL	X	Ensures that the combinations of values that are stored in the dimension table are unique.
GPM_PREDICTOR	I_GPM_PREDICTOR	X	Ensures that the combinations of values that are stored in the dimension table are unique.
GPM_RESULT	I_GPM_RESULT	X	Ensures that the combinations of values that are stored in the dimension table are unique.
GROUP_ANNEX	I_GROUP_ANNEX_END_TS		Improves access time, based on the End Timestamp.
GROUP_ANNEX	I_GROUP_ANNEX	X	Improves access time, based on dimension values.
INTERACTION_DESCRIPTOR	I_INTERACTION_DESCRIPTOR	X	Ensures that the combinations of values that are stored in the dimension table for each tenant are unique.
INTERACTION_FACT	I_IF_SDT		Improves access time, based on the Start Date Time key.
INTERACTION_FACT	I_IF_CID		Improves access time, based on the Call ID.
INTERACTION_RESOURCE_FACT	I_IRF_SDT		Improves access time, based on the Start Date Time key.
INTERACTION_RESOURCE_FACT	I_IRF_PT_GUID	X	Reserved.
INTERACTION_RESOURCE_FACT	IDX_IRF_IID		Improves access time, based on the INTERACTION ID.
IRF_USER_DATA_CUST_1	I_IRF_USER_DATA_CUST_1_SDT		Improves access time, based on the Start Date Time key.
IRF_USER_DATA_GEN_1	I_IRF_USER_DATA_GEN_1_SDT		Improves access time, based on the Start Date Time key.
IRF_USER_DATA_KEYS	I_IRF_USER_DATA_KEYS_SDT		Improves access time, based on the Start Date Time key.
IXN_RESOURCE_STATE_FACT	I_IRSF_SDT		Improves access time, based on the Start Date Time key.
LDR_CAMPAIGN	I_LDR_CAMPAIGN	X	Ensures that the combinations of values that are stored in the dimension table are unique.
LDR_DEVICE	I_LDR_DEVICE	X	Ensures that the combinations of values that are stored in the dimension table are unique.
LDR_FACT	I_LDR_FACT_SDT		Improves access time, based on the Start Date Time key.
LDR_GROUP	I_LDR_GROUP	X	Ensures that the combinations of values that are stored in the dimension table are unique.
LDR_LIST	I_LDR_LIST	X	Ensures that the combinations of values that are stored in the dimension table are unique.
LDR_POSTAL_CODE	I_LDR_POSTAL_CODE	X	Ensures that the combinations of values that are stored in the dimension table are unique.
LDR_RECORD	I_LDR_RECORD	X	Ensures that the combinations of values that are stored in the dimension table are unique.
MEDIATION_SEGMENT_FACT	I_MSF_SDT		Improves access time, based on the Start Date Time key.
MEDIATION_SEGMENT_FACT	I_MSF_IID		Improves access time, based on the INTERACTION ID.
MEDIA_ORIGIN	I_MEDIA_ORIGIN	X	Ensures that the combinations of values that are stored in the dimension table are unique.
MEDIA_TYPE	I_MEDIA_TP_MCD	X	Ensures that the combinations of values that are stored in the dimension table are unique.
POST_CALL_SURVEY_DIM_1	I_POST_CALL_SURVEY_DIM_1	X	Improves access time.
POST_CALL_SURVEY_DIM_2	I_POST_CALL_SURVEY_DIM_2	X	Improves access time.
POST_CALL_SURVEY_DIM_4	I_POST_CALL_SURVEY_DIM_4	X	Improves access time.
POST_CALL_SURVEY_DIM_5	I_POST_CALL_SURVEY_DIM_5	X	Improves access time.
POST_CALL_SURVEY_DIM_6	I_POST_CALL_SURVEY_DIM_6	X	Improves access time.
RESOURCE_	IDX_RES_CFG_DBID	X	Reserved.
RESOURCE_	IDX_RES_TYPE_CODE		Improves access time, based on the code for the resource type.
RESOURCE_	I_RES_KEY_CFG_DBID	X	Reserved.
RESOURCE_ANNEX	I_RESOURCE_ANNEX	X	Improves access time, based on dimension values.
RESOURCE_ANNEX	I_RESOURCE_ANNEX_END_TS		Improves access time, based on the End Timestamp.
SDR_ACTIVITIES_FACT	I_SDR_ACTIVITIES_FACT_SDT		Improves access time, based on the Start Date Time key.
SDR_ACTIVITY	I_SDR_ACTIVITY	X	Ensures that the combinations of values that are stored in the dimension table are unique.
SDR_APPLICATION	I_SDR_APPLICATION	X	Ensures that the combinations of values that are stored in the dimension table are unique.
SDR_BOTS_FACT	I_SDR_BOTS_FACT_SDT		Improves access time, based on the Start Date Time key.
SDR_CALL_DISPOSITION	I_SDR_CALL_DISPOSITION	X	Ensures that the combinations of values that are stored in the dimension table are unique.
SDR_CALL_TYPE	I_SDR_CALL_TYPE	X	Ensures that the combinations of values that are stored in the dimension table are unique.
SDR_CUST_ATRIBUTES	I_SDR_CUST_ATRIBUTES	X	Ensures that the combinations of values that are stored in the dimension table are unique.
SDR_CUST_ATRIBUTES_FACT	I_SDR_CUST_ATRIBUTES_FACT_SDT		Improves access time, based on the Start Date Time key.
SDR_ENTRY_POINT	I_SDR_ENTRY_POINT	X	Ensures that the combinations of values that are stored in the dimension table are unique.
SDR_EXIT_POINT	I_SDR_EXIT_POINT	X	Ensures that the combinations of values that are stored in the dimension table are unique.
SDR_EXT_HTTP_REST	I_SDR_EXT_HTTP_REST	X	Ensures that the combinations of values that are stored in the dimension table are unique.
SDR_EXT_REQUEST_FACT	I_SDR_EXT_REQUEST_FACT_SDT		Improves access time, based on the Start Date Time key.
SDR_EXT_REQUEST_OUTCOME	I_SDR_EXT_REQUEST_OUTCOME	X	Ensures that the combinations of values that are stored in the dimension table are unique.
SDR_EXT_SERVICE_OUTCOME	I_SDR_EXT_SERVICE_OUTCOME	X	Ensures that the combinations of values that are stored in the dimension table are unique.
SDR_GEO_LOCATION	I_SDR_GEO_LOCATION	X	Ensures that the combinations of values that are stored in the dimension table are unique.
SDR_INPUT	I_SDR_INPUT	X	Ensures that the combinations of values that are stored in the dimension table are unique.
SDR_INPUT_OUTCOME	I_SDR_INPUT_OUTCOME	X	Ensures that the combinations of values that are stored in the dimension table are unique.
SDR_LANGUAGE	I_SDR_LANGUAGE	X	Ensures that the combinations of values that are stored in the dimension table are unique.
SDR_MESSAGE	I_SDR_MESSAGE	X	Ensures that the combinations of values that are stored in the dimension table are unique.
SDR_MILESTONE	I_SDR_MILESTONE	X	Ensures that the combinations of values that are stored in the dimension table are unique.
SDR_SESSION_FACT	I_SDR_SESSION_FACT_SDT		Improves access time, based on the Start Date Time key.
SDR_SURVEY_ANSWERS	I_SDR_SURVEY_ANSWERS	X	Ensures that the combinations of values that are stored in the dimension table are unique.
SDR_SURVEY_FACT	I_SDR_SURVEY_FACT_SDT		Improves access time, based on the Start Date Time key.
SDR_SURVEY_I1	I_SDR_SURVEY_I1	X	Improves access time, based on the CREATE_AUDIT_KEY value.
SDR_SURVEY_I2	I_SDR_SURVEY_I2	X	Improves access time, based on the CREATE_AUDIT_KEY value.
SDR_SURVEY_QUESTIONS	I_SDR_SURVEY_QUESTIONS	X	Ensures that the combinations of values that are stored in the dimension table are unique.
SDR_SURVEY_QUESTIONS_I1	I_SDR_SURVEY_QUESTIONS_I1	X	Improves access time, based on the CREATE_AUDIT_KEY value.
SDR_SURVEY_QUESTIONS_I2	I_SDR_SURVEY_QUESTIONS_I2	X	Improves access time, based on the CREATE_AUDIT_KEY value.
SDR_SURVEY_QUESTIONS_S1	I_SDR_SURVEY_QUESTIONS_S1	X	Improves access time, based on the CREATE_AUDIT_KEY value.
SDR_SURVEY_QUESTIONS_S2	I_SDR_SURVEY_QUESTIONS_S2	X	Improves access time, based on the CREATE_AUDIT_KEY value.
SDR_SURVEY_S1	I_SDR_SURVEY_S1	X	Improves access time, based on the CREATE_AUDIT_KEY value.
SDR_SURVEY_S2	I_SDR_SURVEY_S2	X	Improves access time, based on the CREATE_AUDIT_KEY value.
SDR_SURVEY_SCORES	I_SDR_SURVEY_SCORES	X	Improves access time, based on the CREATE_AUDIT_KEY value.
SDR_SURVEY_STATUS	I_SDR_SURVEY_STATUS	X	Improves access time, based on the CREATE_AUDIT_KEY value.
SDR_SURVEY_TRANSCRIPT_FACT	I_SDR_SRV_TRANSCRIPT_FACT_SDT		Improves access time, based on the Start Date Time key.
SDR_USER_INPUT	I_SDR_USER_INPUT	X	Ensures that the combinations of values that are stored in the dimension table are unique.
SDR_USER_INPUTS_FACT	I_SDR_USER_INPUTS_FACT_SDT		Improves access time, based on the Start Date Time key.
SDR_USER_MILESTONE_FACT	I_SDR_USER_MILESTONE_FACT_SDT		Improves access time, based on the Start Date Time key.
SM_RES_SESSION_FACT	I_SM_RS_SSSN_SDT		Improves access time, based on the Start Date Time key.
SM_RES_STATE_FACT	I_RSSF_SDT		Improves access time, based on the Start Date Time key.
SM_RES_STATE_FACT	I_RSSF_RMESSSR		Improves access time.
SM_RES_STATE_REASON_FACT	I_RSRF_SDT		Improves access time, based on the Start Date Time key.
STG_TRANSFORM_DISCARDS	I_S_TRNFRM_DISCARDS_IXNID		Improves access time, based on the INTERACTION ID.
STG_TRANSFORM_DISCARDS	I_S_TRNFRM_DISCARDS_SDT		Improves access time, based on the ETL_DATE_TIME key.
USER_DATA_CUST_DIM_1	I_USER_DATA_CUST_DIM_1	X	Ensures that the combinations of values that are stored in the dimension table are unique.
USER_DATA_GEN_DIM_1	I_USER_DATA_GEN_DIM_1	X	Reserved for internal use.
USER_DATA_GEN_DIM_2	I_USER_DATA_GEN_DIM_2	X	Reserved for internal use.