[AccessD] Indexes in Access

Mark Whittinghill mwhittinghill at symphonyinfo.com
Tue Jun 10 11:29:08 CDT 2003


Hi all,

   I know how Access creates an index automatically when a field is used in
a relationship.  For example, if a table is joined on PersonID, there is an
index on PersonID, even though I won't see it in the list of table indices
in design view.  I would think this index would also be used to speed up
searches, like an index I would add myself, in which case I wouldn't want to
add an Index for PersonID, as that field would have duplicate indices.
Correct?

Mark Whittinghill
Symphony Information Services
612-333-1311
mwhittinghill at symphonyinfo.com



More information about the AccessD mailing list