[AccessD] Joining Tables

Charlotte Foust cfoust at infostatsystems.com
Fri Oct 10 10:14:13 CDT 2008


It should run faster because it can deal with the indexes rather than
parsing the data in each field and examining all records.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester
Sent: Friday, October 10, 2008 7:54 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Joining Tables

Will a query run faster if index fields are joined between tables as
opposed to non indexed fields? I am thinking it will run more quickly
but am interested in others thoughts.


Chester Kaup

Engineering Technician

Kinder Morgan CO2 Company, LLP

Office (432) 688-3797

FAX (432) 688-3799





No trees were killed in the sending of this message. However a large
number of electrons were terribly inconvenienced.

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




More information about the AccessD mailing list