indexing: how much is enough

  • Thread starter Thread starter Mark Kubicki
  • Start date Start date
M

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
 
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
Click to expand...

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.
 
Back
Top