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 SP1

Component : Risk Authentication

Resolution

Below are the recommendations to improve the performance:

• Remove the existing index IDX_ARRFSYSAUDITLOG_DL from the table ARRFSYSAUDITLOG. For more information, you may refer to the product documentation 
• Replicate the Indexes of ARRFSYSAUDITLOG table except IDX_ARRFSYSAUDITLOG_DL for ARRFSYSAUDITLOG_AR.