AFAIK Oracle still use the locking mechanism when we try to update or delete
records on parent tables, but it should be very short since starting from
Oracle 9i, it creates savepoint, take a lock and immediately release it, and
will rollback operation when needed. Not like prior version where the lock
will be held until the update or delete operation on parent table completed

Regards,

Wendry.

----- Original Message -----
From: "Amy" <oracledba-ezmlmshield-x34455462.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Tuesday, August 31, 2004 7:58 AM
Subject: fk indexes? rumor or fact


> Being a data warehouser, I haven't kept up on the whole FK and index
> thing. I'm running version 9.2 for an OLTP database.
>
> Are indexes on the FK columns required still to prevent locking?
>
>
>
> Amy Loukota
> Oracle Certified DBA
> 1150 E University Dr, Suite 100
> Tempe, AZ 85281
> Office: 480-774-5652
> Email: amy.[Email address protected]
> AIM: amyloukota
>
> This message may contain confidential and/or privileged information. If
> you are not the addressee or authorized to receive this for the
> addressee, you must not use, copy, disclose, or take any action based on
> this message or any information herein. If you have received this
> message in error, please advise the sender immediately by reply e-mail
> and delete this message. Thank you for your cooperation.
>
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
>



Oracle LazyDBA home page