| insert into [message #188629] |
Mon, 21 August 2006 01:44  |
steffeli
Messages: 112
Registered: July 2006
|
Senior Member |
|
|
Hello
I have five tables with the same field structure and several billion records each. Now I want to union these tables into a new result-table.
So far, I insert the records of each table into the new result table with "insert into". Unfortunately, this is very slow. Is there a faster way to do this?
Thanks
Stefan
|
|
|
|
| Re: insert into [message #188635 is a reply to message #188629] |
Mon, 21 August 2006 02:01  |
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
|
Senior Member |
|
|
CREATE TABLE big_un
PARALLEL
AS
SELECT *
FROM big_un1
UNION ALL
SELECT *
FROM big_un2
Ross Leishman
|
|
|
|
| Re: insert into [message #188645 is a reply to message #188635] |
Mon, 21 August 2006 02:19 |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
Can you disable Logging with parallel inserts?
If so, that would speed things up too.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
