How many records are you talking about? If it's less than ten thousand, it
probably doesn't matter.

You could get out a stopwatch and test which works faster.

Then there's always Showplan which will tell you what index, if any, that is
being used by a query.

http://articles.techrepublic.com.com...1-5064388.html
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Petr Danes" wrote:

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


--
This e-mail address is fake, to keep spammers and their address harvesters
out of my hair. If you want to get in touch personally, I am 'pdanes' and I
use yahoo mail. But please use the newsgroup when possible, so that all may
benefit from the exchange of ideas.


.