Skip to content
  • Java And Other Languages
  • jOOQ and jOOλ
  • jOOQ Tuesdays and Guest Posts
  • SQL Features and Tuning
  • Thoughts on Programming

Java, SQL and jOOQ.

Best Practices and Lessons Learned from Writing Awesome Java and SQL Code. Get some hands-on insight on what's behind developing jOOQ.

Tag: meta data matters

How schema meta data impacts Oracle query transformations

Posted on November 25, 2011July 23, 2012 by lukaseder

I was recently wondering about some issue I had encountered between two tables. If tables undergo a lot of INSERT / UPDATE / DELETE statements, it may appear to be better to remove some constraints, at least temporarily for the loading of data. In this particular case, the foreign key relationship was permanently absent and … Continue reading How schema meta data impacts Oracle query transformations →

  • Share on Facebook (Opens in new window) Facebook
  • Share on LinkedIn (Opens in new window) LinkedIn
  • Share on X (Opens in new window) X
  • Share on Reddit (Opens in new window) Reddit
  • More
  • Email a link to a friend (Opens in new window) Email
  • Print (Opens in new window) Print

Like this:

Like Loading...
Tagged constraints, foreign key, meta data matters, sql, tom kyte5 Comments

Like this blog? Check out our the best way to write SQL in Java:

jOOQ: Get Back in Control of Your SQL

Don’t forget to follow us on Twitter

Jump to:

  • Home
  • SQL Tricks and Tuning
  • Thoughts on Programming
  • jOOQ Tuesdays and Guest Posts
  • Java and Other Languages
  • jOOQ and jOOλ

Follow Blog via Email

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 2,142 other subscribers
jOOQ: Get Back in Control of Your SQL

About

Learn more about jOOQ

Copyright (c) by Data Geekery GmbH.
Content is licensed CC BY-SA 3.0

 

Subscribe to this blog

↑ Back to top

 

Loading Comments...
 

    %d