Hi -
As usual - "it depends".
In this case, it depends on whether or not oldValue and/or newValue are used
to determine which records to select. If they are not used in the selection
criteria, there would be no point in indexing them.
John
QB wrote:
Correct me if I misunderstood, but I read that one should index fields that
are used as criteria in queries.
With this in mind, when one does a caculated field in a query using multiple
table fields, this means I should index each of these as well?
Ie:
(oldValue - newValue)/oldValue As PercentDiff
I should index oldValue and newValue?
Thank you,
QB
--
John Goddard
Ottawa, ON Canada
jrgoddard at cyberus dot ca
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/201003/1