One more index question.

G

gandalf

I would create the indexes myself instead of relying to
Access to create "hidden" indexes. (Access won't overwrite
existing indexes I hope)
This will also more helpfull if you decide to switch to
another database-engine.

If you doubt that an index is necessary, you could try the
performance analyser in ACCESS.
 
B

Brendan Reynolds

Access will not overwrite an existing index, but it will create an identical
index with a different name. Both indexes will have to be updated whenever
the data changes, so there is a performance hit, and no compensating
benefit - what's the point of having two identical indexes?
 
Top