Improve the performance in Risk Authentication report generation?

Products

• CA Advanced Authentication
• CA Advanced Authentication - Risk Authentication (RiskMinder / RiskFort)
• CA Risk Authentication

Issue/Introduction

How can we improve the performance in Risk Auth report generation tasks?

Environment

Release : 9.1.xx (Applicable to all the supported releases.)

Component : Risk Authentication

Resolution

Below are the recommendations to improve the performance:

• Remove the existing index IDX_ARRFSYSAUDITLOG_DL from the table ARRFSYSAUDITLOG. 
• Replicate the Indexes of ARRFSYSAUDITLOG table except IDX_ARRFSYSAUDITLOG_DL for ARRFSYSAUDITLOG_AR.
  
  

  For more Information, please refer to the below product documentation.

  https://techdocs.broadcom.com/us/en/symantec-security-software/identity-security/advanced-authentication/9-1/upgrading/upgrade-from-release-9-x/Performance-Improvement-Recommendation.html

  https://techdocs.broadcom.com/us/en/symantec-security-software/identity-security/advanced-authentication/9-1/upgrading/upgrade-from-release-9-x.html