Hi
Index on referencing key is required in warehouse circumstance, because it
can provide better performance. It's not useful to prevent locking.

R

-----Original Message-----
From: Amy [mailto:oracledba-ezmlmshield-x34455462.[Email address protected]
Sent: 2004Äê8ÔÂ31ÈÕ 8:58
To: LazyDBA Discussion
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