complete (and dangerous) nonsense. normalization is about removing redundancy -- not to save disk storage, but to maintain data consistency. there is the exception of the DWH world, though, where redundancy is not a problem (due to the read-only nature of such environments) and where the redundancy is supposed to result in better performance for high volume data sets. Kind regards, Lex. --------------------------------------------- visit my website at http://www.naturaljoin.nl --------------------------------------------- -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Paul Baumgartel Sent: Thursday, July 29, 2004 16:32 To: oracle-l@xxxxxxxxxxxxx Subject: Normalization Today, I always introduce redundancy into the model whenever it can eliminate an SQL join, but not always. I make my decision based on two criteria: ===== Paul Baumgartel Transcentive, Inc. www.transcentive.com __________________________________ Do you Yahoo!? Yahoo! Mail - You care about security. So do we. http://promotions.yahoo.com/new_mail ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- -- Binary/unsupported file stripped by Ecartis -- -- Type: text/x-vcard -- File: Lex de Haan.vcf ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------