|
|
Posted by Mork69 on 04/28/07 08:53
Hi,
The quickest way to do this is to use INSERT INTO...SELECT FROM as it
is a non-logged operation
regards,
Malc
B D Jensen wrote:
> Hello!
> I have an big table with 50Gb data, written som functions
> that cleanup data and want to do something like this
>
> insert into newtable
> select id, func1(col1), func2(col2)
> from oldtable;
>
> I'm also plan to make newtable partioned (before insert).
>
> But how could i get the insert as fast as possible?
> Greetings
> Bjorn D. Jensen
Navigation:
[Reply to this message]
|