The Artima Developer Community
Sponsored Link

Java Buzz Forum
Don’t forget to index your Oracle foreign keys

0 replies on 1 page.

Welcome Guest
  Sign In

Go back to the topic listing  Back to Topic List Click to reply to this topic  Reply to this Topic Click to search messages in this forum  Search Forum Click for a threaded view of the topic  Threaded View   
Previous Topic   Next Topic
Flat View: This topic has 0 replies on 1 page
Christopher Wong

Posts: 124
Nickname: cwong15
Registered: Sep, 2009

Christopher Wong is a senior software engineer at lifeIMAGE.
Don’t forget to index your Oracle foreign keys Posted: Jan 15, 2013 9:07 AM
Reply to this message Reply

This post originated from an RSS feed registered with Java Buzz by Christopher Wong.
Original Post: Don’t forget to index your Oracle foreign keys
Feed Title: Chris Wong's Development Blog
Feed URL: http://chriswongdevblog.blogspot.com/feeds/posts/default
Feed Description: This is a development-focused blog covering BlackBerry and Java software development.
Latest Java Buzz Posts
Latest Java Buzz Posts by Christopher Wong
Latest Posts From Chris Wong's Development Blog

Advertisement
This is another note-to-myself blog post. Like PostgreSQL, Oracle does not create indexes on foreign key columns. This can lead to both poor performance and deadlocks. This is because when the parent table’s column where the foreign key points to is updated Oracle needs to verify the child table’s FK constraints. In the absence of an index, this means a full table scan and a table lock. Normally

Read: Don’t forget to index your Oracle foreign keys

Topic: Writing a Tile Engine in JavaFX Previous Topic   Next Topic Topic: Lightweight Web Application Framework: PrimeFaces (JSF) + Guice + MyBatis (Part 2)


Sponsored Links



Google
  Web Artima.com   

Copyright © 1996-2014 Artima, Inc. All Rights Reserved. - Privacy Policy - Terms of Use - Advertise with Us