Database Reference
In-Depth Information
Figure 15-11.
Comparison of loading data with and without direct-path inserts (table without indexes)
Notice that in Figure
15-11
, the undo generation for both direct-path inserts is negligible. This is because the
modified table isn't indexed. Figure
15-12
shows the figures of the same test but with a primary key in place. As
expected, undo for the index segment is generated.
Figure 15-12.
Comparison of loading data with and without direct-path inserts (table with primary key)
Direct-path inserts don't support all objects that conventional inserts do. Their functionality is restricted. If the
database engine can't execute a direct-path insert, the operation is silently converted into a conventional insert. This
happens when one of the following conditions is met:
INSERT
trigger is present on the modified table. (Note that
DELETE
and
UPDATE
triggers have no impact on direct-path inserts.)
•
An enabled
•
An enabled foreign key is present on the modified table (foreign keys of other tables that point