If you substitute the word 'column' for 'variable' in your post, it
would make total sense and the answer to your question would be 'Yes'.

As it stands, I don't understand what you mean e.g. 'a single index on
one variable', 'added an index in Access to this variable' ?!

--

"Nigel" wrote in message ...
Hi All
I have an Access database file (mdb) that I query from Excel, so far the one
table used has a single index on one variable and my SQL string uses the
'select where' based on this variable.

I now wish to query the same table only using a different variable, I have
added an index in Access to this variable. My query was changed to the
'select where' based on this new variable.

Is this all I need to do? I am assuming that the query takes care of using
the appropriate index, is this true? It appears to work on my test dataset
but when I step it up to 200,000 rows I want to make sure the performance is
maintained.

TIA
Cheers
Nigel




----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---