P09631 - Manual Banck Reconcile

Hello,

We are using the bank reconcile program, but we found it is long to reconcile a check, we are looking a way to improve the performance of this program, I did not find any solution in KG.

I trying to find the best index when the user click on "Find".

Is someone has an idea to make this program more adequate ?

Here the query in Jas Server

--

-- JAS log Requête écran P09631

--

SELECT

GLR3, GLCN, GLR2, GLAID, GLLT, GLEXTL, GLCRCD, GLCKNU, GLAA, GLRCND, GLKCO, GLEXA, GLDOC, GLDGJ, GLANI, GLJELN, GLAN8, GLR1, GLDCT, GLACR, GLCO, GLMCU, GLALT1, GLBCRC, GLCRRM