Re: sql question

From: Howard J. Rogers <howardjr_at_www.com>
Date: Wed, 25 Oct 2000 19:35:37 +1000
Message-ID: <39f69bab$2@news.iprimus.com.au>

It means you can do DML on the parent table without the entire child table being locked for the duration of the transaction. In mho, I recommend ALL columns subject to a foregin key constraint should be indexed without even thinking about it, as a result.

Regards
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------

<volk333_at_my-deja.com> wrote in message news:8t5quf$i1n$1_at_nnrp1.deja.com...


> what happens if an index is created on a foreign key column?

> i met this question in some braindump for OCP.

> someone can help me answer this?

> thank you

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.

Received on Wed Oct 25 2000 - 04:35:37 CDT