Index fields in Access

[johnseito]

What happen when you index a field in Access. Does it make your query run quicker ?

[isladogs]

Indexing provide a location bookmark which Access can reference.
This makes searching and filtering MUCH faster in SELECT queries - in tests I've found up to 250x faster.
However it makes UPDATE queries up to 50% slower as the index needs to be updated as well as the field itself

So if you will search more than update, indexing search fields is very useful.
Not all fields should be indexed however. Ignore Yes/No fields for example

I have done various speed comparison tests.
For example, these tests on optimising queries http://www.mendipdatasystems.co.uk/s...s-8/4594556613

[CJ_London]

see this link about indexing

https://www.access-programmers.co.uk...=291268&page=5