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:[email protected]] On Behalf Of Michael Madigan Sent: 06 June 2017 21:36 To: ProFox Email List <[email protected]> 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: [email protected] 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/[email protected] ** 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. _______________________________________________ Post Messages to: [email protected] 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/[email protected] ** 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.
