indexing: how much is enough

[Mark Kubicki]

I have inherited a *.mdb with many tables and many relationships between
them. I've also noticed that there are not a lot of indexed fields.

As a newbie-ish, I suspect that any field that is related to another field
in different table ought to be indexed.

Is this a sound approach?

thanks in advance,
mark

 

[John W. Vinson]

I have inherited a *.mdb with many tables and many relationships between
them. I've also noticed that there are not a lot of indexed fields.

As a newbie-ish, I suspect that any field that is related to another field
in different table ought to be indexed.

Is this a sound approach?

thanks in advance,
mark

A relationship defined in the Relationships window with referential integrity
enforced *will* automatically create indexes on the joining fields. You don't
need to (and indeed shouldn't) create duplicate indexes.