Re: Transactions
From: Tim Boemker <tim_boemker_at_zacatecas.optimum.com>
Date: 29 Dec 1994 14:00:23 GMT
Message-ID: <3dufdn$aho_at_jalisco.optimum.net>
Date: 29 Dec 1994 14:00:23 GMT
Message-ID: <3dufdn$aho_at_jalisco.optimum.net>
In article <788654887snz_at_jlcomp.demon.co.uk> Jonathan_at_jlcomp.demon.co.uk (Jonathan Lewis) writes:
> There is a small hint in one of the manuals about this: Application
> Developers Guide Chapter 6: Using Referential Integrity Constraints.
> For reasons of performance the Oracle engine is basically allowed to
> see the results of uncommited transactions on _indexes_.
>
> Once you figure out why the Parent table is locked if there is no FK
> index on the Child table the necessity for the above becomes clear.
OK, why _is_ the parent table locked if there is no FK index on the child?
Tim Boemker Received on Thu Dec 29 1994 - 15:00:23 CET