[AccessD] Indexes in Access

Jim,

   That's what I thought.  So a query with "WHERE PersonID = 456"  would be
sped up by the auto index created by Referential Integrity?

Mark Whittinghill
Symphony Information Services
612-333-1311
mwhittinghill at symphonyinfo.com
----- Original Message -----
From: "Jim Dettman" <jimdettman at earthlink.net>
To: <accessd at databaseadvisors.com>
Sent: Monday, June 09, 2003 12:00 PM
Subject: RE: [AccessD] Indexes in Access


> Mark,
>
>   Yes, that is correct, almost.  An index is only created on the foreign
> table when you enforce RI.  If you create a relationship without enforcing
> RI, no index is created.  The index is used by Access like any other to
> speed up operations if possible.  And yes, you creating the same index is
> duplicating it.
>
> Jim Dettman
> President,
> Online Computer Services of WNY, Inc.
> (315) 699-3443
> jimdettman at earthlink.net
>