Re: Mystique: Locks, Constraints and Indexes
Date: Fri, 10 Mar 1995 20:12:39 GMT
Message-ID: <michel.lalonde.5.000F3670_at_sit.ulaval.ca>
In article <3jl16j$qig_at_zorn.mnet.medstroms.se> Pauli Salmu <p.salmu_at_mn.medstroms.se> writes:
>From: Pauli Salmu <p.salmu_at_mn.medstroms.se>
>Subject: Mystique: Locks, Constraints and Indexes
>Date: 8 Mar 1995 19:40:03 GMT
>We were getting strange deadlocks in our production DB and finally
>happened to discover that they had something to do with constraints.
>Then we got some help from the local Oracle representatives who said
>that you probably must index every column that has a foreign key
>constraint. Seems crazy, but we tried and here's a simple test.
>DB version is 7.0.15.5.1 in Netware.
Documentation about foreign keys and indexes can be found in Application Developpeur's Guide Page 6-10.
Michel Lalonde :-) Received on Fri Mar 10 1995 - 21:12:39 CET