I suppose that "Insert into ... Select ..." is better.
Printable View
I suppose that "Insert into ... Select ..." is better.
I doubt it. I'd like to see the numbers on that...Quote:
Originally posted by mike9
I understood that you would have to split the partition(s) once you exchanged the partiton. But depending on how many partitons he wants to use it would probably use more time and ressources than simply inserting it once directly in the right partition.
I have to admit that I haven't tested it, if I got some time today I will do it ;)
Mike
"Create table ... nologging as select ..."
... would be the fastest way to build the new table.