Multiple indexes on same fields in different order

  • Thread starter Thread starter Petr Danes
  • Start date Start date
P

Petr Danes

I sometimes need to find the largest or smallest value in a field. If I put
two indexes on the same field, one in ascending order and one in descending
order, is Jet smart enough to use the proper index if a give it a grouping
query with the condition Max or Min, or am I just wasting resources?

Pete
 
Around 80,000. I tried the ShowPlan bit a few days ago, but wasn't able to
find the file that it supposedly creates, so I probably did something wrong.

Also, I'm running this split over a network, with Access for both frontend
and backend, so if I put a proper index on the backend, it might make a
sizable difference in how fast it gets something from an extreme end, no?

Pete
 
Your best bet is to create the indexes and get out a stopwatch. See if it
makes a difference. Tip: Time the second or third execution of the query as
Access often takes extra time to optimize the query in memory on the first
run.
 
Okay, I'll try that.


Jerry Whittle said:
Your best bet is to create the indexes and get out a stopwatch. See if it
makes a difference. Tip: Time the second or third execution of the query
as
Access often takes extra time to optimize the query in memory on the first
run.
Click to expand...
 
Back
Top