[AccessD] Indexes in Access

Mark, you would be duplicating the index, which doesn't really hurt
anything, but does add to count of total indexes -- but few of us every hit
that limit anyway.

What I haven't tested however, is whether these internal (and often
temporary) indexes are removed if you delete the relationship, etc. Anybody
know?

Susan H.


> 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
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>