Article Details
Id:15069
Product:finPOWER Connect
Type:NEW
Version:3.01.00
Opened:29/09/2016
Closed:20/11/2017
Released:23/02/2018
Job: J018130

AccountTransaction table; review indexes

To improve performance of Direct Debit processing, the AccountTransaction table, "IX_AccountTransactionDirect" index, has been modified.

Previously this indexed the columns DirectDebitStatus, Date and AccountPk. This has been amended to DirectDebitStatus, ReversePk and Date. For SQL Server, the column "AccountPk" is an included column.