Re: index on foreign key

From: Howard J. Rogers <howardjr_at_www.com>
Date: 2000/06/09
Message-ID: <39405647$1@news.iprimus.com.au>#1/1

"mcomer" <mcomer2NOmcSPAM_at_hotmail.com.invalid> wrote in message news:139473e4.4b2b2923_at_usw-ex0106-047.remarq.com...
> In an Oracle database, should all foreign key columns have
> indexes?
>

Yup. Without exception. Otherwise, DML on the parent table will lock the entire child table. With an index, Oracle uses pins on the index, and so avoids the problem.
HJR
> Marc
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Fri Jun 09 2000 - 00:00:00 CDT