[AccessD] Indexes in Access

Mark,

  Yes.  It's used like any other index.  It counts towards the 32 index
limit etc.  The only difference is that it is hidden in the table designer.

Jim Dettman
President,
Online Computer Services of WNY, Inc.
(315) 699-3443
jimdettman at earthlink.net

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mark
Whittinghill
Sent: Tuesday, June 10, 2003 3:16 PM
To: accessd at databaseadvisors.com
Subject: Re: [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
>


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com