In 8i and below FK indexes are essential for large OLTP databases.
Otherwise, you will get deadlock under heavy load. I have not evaluated the
problem with 9i or higher. I suspect it is only needed for performance in
9i or higher.
Good Luck,
Chris
----------------------------------------------------
Chris Weiss, Blueoak Database Engineering, LLC
http://www.blueoakdb.com
PH: 517-381-9305
CELL: 517-974-5634
eFAX: 801-340-0740
-----Original Message-----
From: Roger
[mailto:oracledba-ezmlmshield-x82516299.[Email address protected]
Sent: Monday, August 30, 2004 9:54 PM
To: LazyDBA Discussion
Subject: RE: fk indexes? rumor or fact
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
--------
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