View Single Post
  #1  
Old March 22nd, 2010, 08:38 PM posted to microsoft.public.access.tablesdbdesign
QB
external usenet poster
 
Posts: 150
Default Proper Indexing of Table Fields

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