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.