Perhaps that would be a better way of putting it. RF
Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features�(Oracle Press) Mastering Oracle8i� (Sybex) Clark Griswold: Eddie,�has anyone�ever told you that you're bad luck? Cousin Eddie: Those were my mother's dying words. But I guess if your body's covered in third degree burns, and your foot's caught in a bear trap, you tend to start talkin' crazy. -----Original Message----- Sent: Friday, July 19, 2002 5:31 PM To: Multiple recipients of list ORACLE-L I'm not sure if "done away with" is the appropriate term for fk locking, maybe the time exposed to locking is reduced in 9i is better ? hth connor --- "Freeman, Robert" <[EMAIL PROTECTED]> wrote: > Well, that depends on if the FK is enforced or not > too. There should be > minimal > performance impact with an unenforced FK with > regards to inserts. > In a DW FK's are often present but not enforced. > Unenforced FK's in DW's are > used for a number of reasons, query rewrite among > them. > > Some of the old performance and locking issues with > FK's were done away with > in 9i. > > What > > Robert G. Freeman - Oracle OCP > Oracle Database Architect > CSX Midtier Database Administration > Author > Oracle9i RMAN Backup and Recovery (Oracle Press - > Oct 2002) > Oracle9i New Features�(Oracle Press) > Mastering Oracle8i� (Sybex) > > Clark Griswold: Eddie,�has anyone�ever told you that > you're bad luck? > Cousin Eddie: Those were my mother's dying words. > But I > guess if your body's covered in third degree burns, > and > your foot's caught in a bear trap, you tend to start > talkin' > crazy. > > > > -----Original Message----- > Sent: Thursday, July 18, 2002 2:44 PM > To: Multiple recipients of list ORACLE-L > > > Terrible expecially on inserts into the database, it > may have to do a full > table scan to insert one record. Don't do it. > > > >From: "Shishir Kumar Mishra" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > >Subject: Unindexed foreign key > >Date: Thu, 11 Jul 2002 04:13:36 -0800 > > > >Hi Gurus! > >How does the unindexed foreign key affect the > performance ? > > > >regards.... > >Shishir Kumar Mishra > >Agni Software (P) Ltd. > >www.agnisoft.com > >---------------------------------- > >Vidya Dadaati Viniyam > >---------------------------------- > > > > > > > > > Over and out Basher 59 > > > _________________________________________________________________ > Join the world's largest e-mail service with MSN > Hotmail. > http://www.hotmail.com > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: basher 59 > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California -- Public Internet > access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Freeman, Robert > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California -- Public Internet > access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). ===== Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "Remember amateurs built the ark - Professionals built the Titanic" __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
