Databases Reference
In-Depth Information
In step 4 we drop the
MY_SALES
table and recreate and populate it from the
SALES
table at
the same time, using a
CREATE
TABLE
AS
SELECT
statement in step 5.
In the following screenshot we can see the corresponding results:
We can see that the elapsed time is less in the
CREATE
TABLE
when using the select
statement rather than in the direct path loading insert.
In step 6 we inquire about the execution plan for the direct path insert statement in step 3.
In the following screenshot you can see this execution plan: