i have an access database (moving to a different database is not an option) and i am looking to change/enhance the indexing to speed up searches.
a basic search always includes a code specific to the person/group doing the search. within that code, searches are done on 3 or 4 other fields (bill number, registration, last name, first name). question is how should the indexing exist?
if the code is part of every search, should i be creating multi-field indexes with the code in each? such as :
code + bill numb
code + registration
or, should they all be separate indexes such as
lastname + firstname
hope that makes sense?
lastly, does the order of the fields in the WHERE portion of a select statement help speed w/r/t to the indexes?
thank you in advance.
code + bill number as a multi, or should code be a separate index, then bill