> 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?
No, please don't. That's why we use relational databases for transaction
processing. If you've got lots of "little" tables, and you're joining three
or four, you're doing the right thing, generally. It does cost more to
SELECT data, but costs less to find that data (you're more likely to be able
to take advantage of clustered indexes, for example), and costs much less to
modify the data.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------
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.
