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: Mult
ED]>
>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
>
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]
Title: RE: Unindexed foreign key
Shishir,
If there are only a few records in the table, very little. However, if the table is nicely populated, it can make a tremendous difference. You could always do a little testing to find out in your particular case, but I wouldn't bother. I A
recipients of list ORACLE-L
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
--
--
Please see the official ORACLE-L FAQ
Hi Gurus!
How does the unindexed foreign key
affect the performance ?
regards
Shishir Kumar MishraAgni Software (P)
Ltd.www.agnisoft.com--Vidya
Dadaati Viniyam--