You can look at the contents of zenutils.js to see the actual details of the zen(id) function.
The IDX system is oftentimes partitioned by Group(GRP). Additionally I suspect the 86M records do not represent invoices for a single year. Using %SYSTEM.WorkMgr you could break the job up in to smaller jobs by GRP and or InvCrePd or YEAR(BAR.Invoice.SerDt)
Some of the reasons why I focus on utilizing class queries include
Class Queries are really worth investing in IMHO.
Log in or create a new account to continue