Reading Access - Multiple Indices

  • Thread starter Thread starter Nigel
  • Start date Start date
N

Nigel

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
 
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' ?!
 
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 said:
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' ?!
Click to expand...
Encryption =---
 
Back
Top