Jump to: navigation, search

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 Name U Description

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.

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.

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.

COBROWSE_END_REASON

I_COBROWSE_END_REASON X Reserved for future use.

COBROWSE_FACT

I_COBROWSE_FACT_SDT Reserved for future use.

COBROWSE_MODE

I_COBROWSE_MODE X Reserved for future use.

COBROWSE_PAGE

I_COBROWSE_PAGE X Reserved for future use.

COBROWSE_USER_AGENT

I_COBROWSE_USER_AGENT X Reserved for future use.

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_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.

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_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_3

I_POST_CALL_SURVEY_DIM_3 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_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

I_SDR_EXT_REQUEST 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.

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on 18 August 2016, at 15:05.