Jim Dettman
jimdettman at earthlink.net
Mon Jun 9 13:00:30 CDT 2003
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 -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mark Whittinghill Sent: Tuesday, June 10, 2003 12:29 PM To: accessd at databaseadvisors.com Subject: [AccessD] Indexes in Access 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