even this is happening in 8i.

but my boss dont want to consider indexing foreign key.

When i say "BOSS" i belive you know the definition and meaning of "BOSS".

;)

chandra

Pusarla Rambabu wrote:

>As a simple rule of thumb, Having an index on foreign keys is useful for
>both performance and avoiding deadlocks. This applies to Oracle and SQL
>Server
>
>Regards,
>Rambabu
>
>
> -----Original Message-----
>From: Chris Weiss
>[mailto:oracledba-ezmlmshield-x96117204.[Email address protected]
>Sent: Tuesday, August 31, 2004 7:46 AM
>To: LazyDBA Discussion
>Subject: RE: fk indexes? rumor or fact
>
>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
>
>
>
>--------
>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