Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: CTAS versus INSERT
Carlos Alberto wrote:
> Hi,
>
> I want to load a large volume of data into a table. I was wondering
> what would be better : use CREATE TABLE AS SELECT, or create the table
> empty and then make INSERT. Both of options would use the NOLOGGING
> clause. I wonder CTAS would be faster, because in this case (almost)
> no log would be generated, instead of INSERT, which always generates
> log. Is it right?
>
> Thanks in advanced,
> Carlos
Neither option, and none available, completely turns off logging.
To know which is faster ... do it twice ... once each way.
But "a large volume of data" is very ambiguous. To me it might mean gigabytes while to you tens of megabytes.
Daniel Morgan Received on Mon May 27 2002 - 17:44:30 CDT