Re: How make data transfomation faster?

>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