The Artima Developer Community
Articles | News | Weblogs | Books | Forums
Artima Forums | Articles | Weblogs | Java Answers | News
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: 128
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 6: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: SLF4J Logging in Eclipse Plugins Previous Topic   Next Topic Topic: Developer divide: 19 generations of computer programmers
Sponsored Links


Google
  Web Artima.com   

Copyright © 1996-2019 Artima, Inc. All Rights Reserved. - Privacy Policy - Terms of Use