Search notes:

Oracle SQL Plan operation: LOAD AS SELECT

The LOAD AS SELECT plan operation indicates that data is inserted into a table using the direct path (as opposed to the conventional path).

create table tq84_src (id number, val varchar2(100));

explain plan for
create table tq84_dest as
select * from tq84_src;

select * from table(dbms_xplan.display(format=>'basic'));
--
-- ------------------------------------------------------
-- | Id  | Operation                        | Name      |
-- ------------------------------------------------------
-- |   0 | CREATE TABLE STATEMENT           |           |
-- |   1 |  LOAD AS SELECT                  | TQ84_DEST |
-- |   2 |   OPTIMIZER STATISTICS GATHERING |           |
-- |   3 |    TABLE ACCESS FULL             | TQ84_SRC  |
-- ------------------------------------------------------


create table tq84_dest as
select * from tq84_src;

explain plan for
insert /*+ append */ into tq84_dest
select * from tq84_src;

select * from table(dbms_xplan.display(format=>'basic'));
--
-- ------------------------------------------------------
-- | Id  | Operation                        | Name      |
-- ------------------------------------------------------
-- |   0 | INSERT STATEMENT                 |           |
-- |   1 |  LOAD AS SELECT                  | TQ84_DEST |
-- |   2 |   OPTIMIZER STATISTICS GATHERING |           |
-- |   3 |    TABLE ACCESS FULL             | TQ84_SRC  |
-- ------------------------------------------------------

Oracle SQL Plan operation: LOAD AS SELECT

See also