Re: How make data transfomation faster?

to Joel
>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.

I'm starting to think that there is no way to make it in SQL. If you know how to do it, please tell me.

>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?

I'm on windows. And this task should be done every day. In SQL or PL/SQL I can use jobs and go home. Actualy I can write a little programm to update it, but I want to do it in Oracle. Because in program I can't use indexes and optimazer. And in program I should use full scan and use a lot of memory (about same memory as using table of). Received on Fri Feb 03 2006 - 21:17:15 CST