I'm fairly certain that view does not ehance performance. It is their for easy of use etc >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.
