Reading Access - Multiple Indices
 

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 =---

Reading Access - Multiple Indices
 

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 =---

Reading Access - Multiple Indices
 

OK thanks, sorry about the teminology, I'm an SPSS user and the terms
variables and cases are more common to me as far as databases are concerned.

In terms of the Access Table, I had one 'column' with an index initially. I
subsequently changed another column to also have an index. both 'allow
duplicates'

Cheers
Nigel

"onedaywhen" wrote in message
om...
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 =---




----== 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 =---