Multifield Index and Single field index

[Susan K]

I have created a multifield index on a table that is usually searched on
those fields in combination. But there are also situations where one of
those fields alone is searched. Do I need to create another index for that
single field or will Access97 use the information in the multifield index??

 

[Peter Jphal]

Susan

If the field you're searching is the first field in the multifield index, then you can use the multifield index. Otherwise you have to create a new index

Peter

 

[John Vinson]

I have created a multifield index on a table that is usually searched on
those fields in combination. But there are also situations where one of
those fields alone is searched. Do I need to create another index for that
single field or will Access97 use the information in the multifield index??

It depends. If you're searching on the first field in the index (alone
or in combination with one or more other fields), Access will still
take advantage of the index. If you're searching only on a field or
fields other than the first, the search will still work but may be a
lot slower since it will need to do a full table scan.