Re: Index and Foreign key
From: James Williams <willjamu_at_mindspring.com>
Date: Mon, 28 Apr 2003 00:34:27 GMT
Message-ID: <3eac76c6.53752522_at_nntp.mindspring.com>
Date: Mon, 28 Apr 2003 00:34:27 GMT
Message-ID: <3eac76c6.53752522_at_nntp.mindspring.com>
[Quoted] On Sat, 26 Apr 2003 08:01:58 +0000 (UTC), "Salim Harouat" <salimharouat_at_aol.com> wrote:
It is important to index all foreign key columns as a general rule even though 9i adds some features to migitate the effects (ora-0060's) of a parent causing the entire child table to be locked for the duration of the operation.
>Hi Everybody,
>
> I wish to optimize certain queries done on a Oracle database to gain
>in response times. With this intention, I plan to pose a non unique
>index on each foreign key of the base. Am i right ?
>
>Thank u for everything
>
>
>--
>Posted via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Mon Apr 28 2003 - 02:34:27 CEST