Simon, You may want to create a view that contains the tables that you want to join. I don't know the performance results of a view versus the multiple joins. It'll be cleaner for coding to reference a view than the multiple tables. /Ron -----Original Message----- From: Park, Simon [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 20, 2000 8:51 AM To: '[EMAIL PROTECTED]' Subject: Another li'l OT - performance penalty for joining 3 or more tables Thanks for the help on the incrementing field value question. I have another question.. How bad is it, performance-wise, to join 3 or 4 tables in a SELECT statement? I could re-design the tables to include redundant fields so I join fewer tables. Should I? =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Simon Park Computer Systems Management, Inc. [EMAIL PROTECTED] 205 South Whiting Street Ph: 703-823-4300 Suite 201 fax: 703-823-4301 Alexandria, VA 22304 http://www.csmi.com ---------------------------------------------------------------------------- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. ------------------------------------------------------------------------------ Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
