Yes, I was just wondering since it doesn't have to do the calculation every time it updates
From: Dave Crozier DaveC@Flexipol.co.uk To: ProFox Email List profox@mail.leafe.com Sent: Wednesday, June 7, 2017 8:05 AM Subject: RE: Is there any advantage for indexing on balance rather than on principle - payments +adjustments?
It's not the index that is the problem, it is how you structure the query based on the index that really matters.
Dave
-----Original Message----- From: ProFox [mailto:profox-bounces@mail.leafe.com] On Behalf Of Michael Madigan Sent: 06 June 2017 21:36 To: ProFox Email List profox@leafe.com Subject: Is there any advantage for indexing on balance rather than on principle - payments +adjustments?
When creating an index , Is there any advantage for indexing on balance rather than on principle - payments +adjustments?
Index on balance tag balanceindex on principle - payments + adjustments tag balance Right now we don't have a balance field, would there be any advance to add a balance fields?
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
[excessive quoting removed by server]