... the index should be designed based on what the query will be analysing not the other way around.
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 ---
_______________________________________________ Post Messages to: ProFox@mail.leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/1725843443.3868491.1496781341558@mail... ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.