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@nntp.mindspring.com>

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 Sun Apr 27 2003 - 19:34:27 CDT