Identify database's indices
Introduction
The Identify/IdentifyAudit database can contain a large amount of data, and having necessary indices is essential for efficiently querying data. Below, you can find the list of all changed indices in version 5.15 of the Identify instance.
List of indices on Identify database
List of indices on the Identify database is:
| Table or View | Index name in version 5.14 | Index name in version 5.15 |
|---|---|---|
| AttributeServiceConnection | IX_AttributeServiceConnection__ConfigurationId | Unchanged |
| AuthenticationConnectionBearingClaimValue | UQ_V_AuthenticationConnectionBearingClaimValue | IXC_AuthenticationConnectionBearingClaimValue__ClaimId_AuthConnId_UserId_Value |
| ClaimDefinition | UQ__ClaimDef__system-generatedID | IXU_ClaimDefinition__ClaimType |
| ClaimMappingTransformation | UQ_ClaimMappingTransformation | IXU_ClaimMappingTransformation__Id_Source_Destination |
| ClaimsSet | UQ__ClaimsSe__system-generatedID | IXU_ClaimsSet__Name |
| ClaimsTransformationAuthenticationConnection | OU_AuthenticationConnectionIndex | IXU_ClaimsTransformationAuthenticationConnection__AuthnConnectionId_Index |
| ClaimsTransformationProtocolConnection | OU_ProtocolConnectionIndex | IXU_ClaimsTransformationProtocolConnection__ProtocolConnectionId_Index |
| ClaimTransformation | OU_Name | IXU_ClaimTransformation__Name |
| Connection | IXDU_Connection__Name | IXU_Connection__Name |
| ConnectionUserConsent | IX_ConnectionUserConsent__ConnectionId | Unchanged |
| ConnectionUserConsent | IX_ConnectionUserConsent__UserId | Unchanged |
| ConnectionUserConsent | IX_ConnectionUserConsent__NonUserUniqueKey | Unchanged |
| DataStore | IXD_DataStore__DataType_Key | IXU_DataStore__DataType_Key |
| DataStore | IXD_DataStore__Status_DataType_NextCheckDate_LastCheckDate | IX_DataStore__Status_DataType_NextCheckDate_LastCheckDate |
| DeviceAuthorizationResponse | Idx_HashedUserCode | IX_DeviceAuthorizationResponse__HashedUserCode |
| DeviceAuthorizationResponse | Idx_HashedDeviceCode | IX_DeviceAuthorizationResponse__HashedDeviceCode |
| DiscreteClaimOption | U_DiscreteClaimOption | IXU_DiscreteClaimOption__ClaimDefinitionId_Value |
| DiscreteGroupClaimValue | U_DiscreteGroupClaimValue | IXU_DiscreteGroupClaimValue__GroupId_DiscreteClaimId |
| DiscreteUserClaimValue | IDX_DiscreteUserClaimValue__DiscreteClaimId__UserId | IXU_DiscreteUserClaimValue__UserId_DiscreteClaimId |
| FreeUserClaimValue | IXU_FreeUserClaimValue__UserId_FreeClaimId | Unchanged |
| FreeUserClaimValue | IDX_FreeUserClaimValue__ClaimDefinitionId__IsPrimary__UserId__Value | IX_FreeUserClaimValue__ClaimDefinitionId_IsPrimary_UserId_Value |
| IssuedArtifact | IDX_MessageHandle | IXU_IssuedArtifact__MessageHandle |
| LdapAttributeDefinition | IDX_SharedConfigurableSetting_LdapName | IXU_SharedConfigurableSetting__LdapName |
| MetadataMonitoring | Idx_Connection | IX_MetadataMonitoring__ConnectionId |
| NameClaimTypedUserCredential | U_NameClaimTypedUserCredential | IXC_NameClaimTypedUserCredential__UserName_AuthnId_NameClaimType |
| NonUserRestrictedActionAttempt | IX_NonUserRestrictedActionAttempt | IX_NonUserRestrictedActionAttempt__NonUserUniqueKey_ActionType_AuthnConnId |
| OAuthAccessToken | Idx_HashedCode | IX_OAuthAccessToken__HashedCode |
| OAuthAccessToken | Idx_UserInfoSessionId | IX_OAuthAccessToken__UserInfoSessionId |
| OAuthAccessToken | N/A | IX_OAuthAccessToken__ProtocolConnectionId_ExpirationDate_RefreshTokenExpirationDate |
| OAuthAccessToken | N/A | IX_OAuthAccessToken__ExpirationDate_RefreshTokenExpirationDate |
| OAuthAccessToken | Idx_UserId_ProtocolConnId | IX_OAuthAccessToken__UserId_ProtocolConnId |
| PasswordHistory | IX_PasswordHistory__UserId_InsertedDate | Unchanged |
| PersistentPseudonym | UQ_PP_UserId_ProtocolConnectionId | IXU_PersistentPseudonym__UserId_ProtocolConnectionId |
| ResetPasswordOutcome | IX_ResetPasswordOutcome__UserId | Unchanged |
| SharedConfigurableSetting | IDX_SharedConfigurableSetting_Name | IXU_SharedConfigurableSetting__Name |
| User | IX_User__Enabled | Unchanged |
| User | IX_User__ExternalId | Unchanged |
| UserAccountUpdateTransformation | UQ_UserAccountUpdateTransformation | IXU_UserAccountUpdateTransformation__ClaimTransformationId_ClaimDefinitionId |
| UserCertificate | IX_UserCertificate__UserId | Unchanged |
| UserCertificate | IXU_UserCertificate__CertificateThumbprint | Unchanged |
| UserRestrictedActionAttempt | IX_UserRestrictedActionAttempt | IX_UserRestrictedActionAttempt__UserId_ActionType_AuthnConnId |
| UserSecondFactorCode | IX_UserSecondFactorCode__UserId | Unchanged |
| UserSecondFactorCode | IX_UserSecondFactorCode__OtpConnectionId | Unchanged |
| UserSecondFactorDeviceRegistration | IX_UserSecondFactorDeviceRegistration__User_Connection_Device_Type | Unchanged |
| UserThirdPartyData | IX_UserThirdPartyData__LastLoggedInDateTime | Unchanged |
List of indices on IdentifyAudit database
List of indices on the IdentifyAudit database is:
| Table or View | Index name in version 5.14 | Index name in version 5.15 |
|---|---|---|
| AuditAdminSiteAuthentication | Idx_AuditAdminSiteAuthentication_AuditEventId | IX_AuditAdminSiteAuthentication__AuditEventId |
| AuditAttributeServiceConnection | Idx_AuditAttributeServiceConnection_AuditEventId IX_AuditAttributeServiceConnection__AuditEventId | |
| AuditAuthenticationConnection | Idx_AuditAuthenticationConnection_AuditEventId | IX_AuditAuthenticationConnection__AuditEventId |
| AuditAuthenticationContextMethodClass | Idx_AuditAuthenticationContextMethodClass_AuditEventId | IX_AuditAuthenticationContextMethodClass__AuditEventId |
| AuditClaimDefinition | Idx_AuditClaimDefinition_AuditEventId | IX_AuditClaimDefinition__AuditEventId |
| AuditClaimSet | Idx_AuditClaimSet_AuditEventId | IX_AuditClaimSet__AuditEventId |
| AuditClaimsIssuance | Idx_AuditClaimsIssuance_AuditEventId | IX_AuditClaimsIssuance__AuditEventId |
| AuditClaimTransformation | Idx_AuditClaimTransformation_AuditEventId | IX_AuditClaimTransformation__AuditEventId |
| AuditConnectionClaimSets | IX_AuditConnectionClaimSets__ConnectionId | IX_AuditConnectionClaimSets__ConnectionId |
| AuditConnectionUserConsent | IX_AuditConnectionUserConsent__ConnectionId | Unchanged |
| AuditConnectionUserConsent | IX_AuditConnectionUserConsent__UserId | Unchanged |
| AuditConnectionUserConsent | IX_AuditConnectionUserConsent__NonUserUniqueKey | Unchanged |
| AuditCorrelationError | Idx_AuditCorrelationError_AuditEventId | IX_AuditCorrelationError__AuditEventId |
| AuditCryptoKey | IXD_AuditCryptoKey__AuditEventId | IX_AuditCryptoKey__AuditEventId |
| AuditDataStore | Idx_AuditDataStore_AuditEventId | IX_AuditDataStore__AuditEventId |
| AuditDeviceAuthorizationResponse | IXD_AuditDeviceAuthorizationResponse__AuditEventId | IX_AuditDeviceAuthorizationResponse__AuditEventId |
| AuditDeviceAuthorizationResponse | IXD_AuditDeviceAuthorizationResponse__DeviceCode | IX_AuditDeviceAuthorizationResponse__DeviceCode |
| AuditDeviceAuthorizationResponse | IXD_AuditDeviceAuthorizationResponse__UserCode | IX_AuditDeviceAuthorizationResponse__UserCode |
| AuditDiscreteClaimValueSpace | Idx_AuditDiscreteClaimValueSpace_AuditEventId | IX_AuditDiscreteClaimValueSpace__AuditEventId |
| AuditEvent | Idx_AuditEvent_UtcTimestamp_Id_EventType | IX_AuditEvent__UtcTimestamp_Id_EventType |
| AuditGroup | Idx_AuditGroup_AuditEventId | IX_AuditGroup__AuditEventId |
| AuditIdentityProviderConfiguration | Idx_AuditIdentityProviderConfiguration_AuditEventId | IX_AuditIdentityProviderConfiguration__AuditEventId |
| AuditIncomingAssertion | Idx_AuditIncomingAssertion_AuditEventId | IX_AuditIncomingAssertion__AuditEventId |
| AuditIssuedArtifact | Idx_AuditIssuedArtifact_AuditEventId | IX_AuditIssuedArtifact__AuditEventId |
| AuditIssuedClaim | Idx_AuditIssuedClaim-ClaimsIssuanceId | IX_AuditIssuedClaim__ClaimsIssuanceId |
| AuditLdapAttributeDefinition | Idx_AuditLdapAttributeDefinition_AuditEventId | IX_AuditLdapAttributeDefinition__AuditEventId |
| AuditMassUpdateUserClaimValue | Idx_AuditMassUpdateUserClaimValue_AuditEventId | IX_AuditMassUpdateUserClaimValue__AuditEventId |
| AuditNonUserRestrictedActionAttempt | IXD_AuditNonUserRestrictedActionAttempt__AuditEventId | IX_AuditNonUserRestrictedActionAttempt__AuditEventId |
| AuditNonUserRestrictedActionAttempt | IXD_AuditNonUserRestrictedActionAttempt__AuthenticationConnectionId__NonUserUniqueKey__ActionType | IX_AuditNonUserRestrictedActionAttempt__AuthenticationConnectionId_NonUserUniqueKey_ActionType |
| AuditOAuthAccessToken | N/A | IX_AuditOAuthAccessToken__ExpirationDate_RefreshTokenExpirationDate |
| AuditOAuthAccessToken | Idx_AuditOAuthAccessToken_AuditEventId | IX_AuditOAuthAccessToken__AuditEventId |
| AuditOrganization | Idx_AuditOrganization_AuditEventId | IX_AuditOrganization__AuditEventId |
| AuditPersistentPseudonym | Idx_AuditPersistentPseudonym_AuditEventId | IX_AuditPersistentPseudonym__AuditEventId |
| AuditPlugIn | Idx_AuditPlugIn_AuditEventId | IX_AuditPlugIn__AuditEventId |
| AuditProtocolConnection | Idx_AuditProtocolConnection_AuditEventId | IX_AuditProtocolConnection__AuditEventId |
| AuditSharedConfigurableSetting | Idx_AuditSharedConfigurableSetting_AuditEventId | IX_AuditSharedConfigurableSetting__AuditEventId |
| AuditTombstone | Idx_AuditTombstone_AuditEventId | IX_AuditTombstone__AuditEventId |
| AuditUser | IXD_AuditUser__UserName | IX_AuditUser__UserName |
| AuditUser | Idx_AuditUser_AuditEventId | IX_AuditUser__AuditEventId |
| AuditUserClaim | Idx_AuditUserClaim-UserId | IX_AuditUserClaim__UserId |
| AuditUserDeviceCookie | Idx_AuditUserDeviceCookie_AuditEventId | IX_AuditUserDeviceCookie__AuditEventId |
| AuditUserRequest | IX_AuditUserRequest__UserRequestEventId | Unchanged |
| AuditUserRequest | Idx_AuditUserRequest_AuditEventId | IX_AuditUserRequest__AuditEventId |
| AuditUserRestrictedActionAttempt | IXD_AuditUserRestrictedActionAttempt__AuditEventId | IX_AuditUserRestrictedActionAttempt__AuditEventId |
| AuditUserRestrictedActionAttempt | IXD_AuditUserRestrictedActionAttempt__AuthenticationConnectionId_UserId__ActionType | IX_AuditUserRestrictedActionAttempt__AuthenticationConnectionId_UserId_ActionType |
| AuditUserSecondFactorCode | IX_AuditUserSecondFactorCode__AuditEventId | Unchanged |
| AuditUserSecondFactorCode | IX_AuditUserSecondFactorCode__UserId | Unchanged |
| AuditUserSecondFactorCode | IX_AuditUserSecondFactorCode__OtpConnectionId | Unchanged |
| Logs | IX_Logs__UserId | Unchanged |
| Logs | IX_Logs__EventId | Unchanged |
| Logs | IX_Logs__RequestId | Unchanged |
| Logs | IX_Logs__TimeStamp_Type_LogLevel | Unchanged |
| Logs | Idx_Logs_Timestamp_LogLevel_LogType_EventId_Id | IX_Logs__Timestamp_LogLevel_LogType_EventId_Id |