Improve the performance in Risk Authentication report generation
search cancel

Improve the performance in Risk Authentication report generation

book

Article ID: 248039

calendar_today

Updated On:

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.