Insert into vs create table as
770280May 5 2010 — edited May 12 2010What is the difference between following 2 options in peformance?
--Option 1:
CREATE TABLE foo(a NUMBER, b NUMBER, c NUMBER);
INSERT INTO foo
(a, b, c)
(SELECT aa,
bb,
cc
FROM mytable);
--Option 2:
CREATE TABLE foo
AS
SELECT aa, bb, cc
FROM mytable;
Thanks