Databases Reference
In-Depth Information
In the following screenshot we can see the results obtained:
We can see that the execution time for the
INSERT
statement is 2.46 seconds instead of
5.30 as in step 3.
Let's observe the difference in the execution plans. The following screenshot shows the plan
from step 6, related to the classical insert statement:
We can see that the statement uses
LOAD
TABLE
CONVENTIONAL
step to fill the
MY_SALES
table with data obtained from a
FULL
TABLE
ACCESS
of
SALES
table.