Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How make data transfomation faster?

Re: How make data transfomation faster?

From: <joel-garry_at_home.com>
Date: 3 Feb 2006 15:42:02 -0800
Message-ID: <1139010122.558801.152960@g14g2000cwa.googlegroups.com>


>This is a brain breaking task. I think that I'm not smart enough for
>it. That's why I need help here.

SQL is set oriented, if you try to put procedural logic into it then you will break your brain. If you can describe the four conditions as sets (such as in normalized views), you can join the sets. If you can't, go back to the COBOL mindset, as that is the design of kind.

If performance is an issue, suck it into flat files and use awk to transform, sqlloader to put it back. For deletes, you'll be slow whatever you do in Oracle, much faster with pipelined unix commands. You are on unix, right?

jg

--
@home.com is bogus.
Telegram  for Mr. Peabody!
http://www.signonsandiego.com/uniontrib/20060203/news_1n3telegram.html
Received on Fri Feb 03 2006 - 17:42:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US