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