What is the best way to insert 100000 records in a table considering the performance issue.
i mean data should be added in the table with least possible time.
Printable View
What is the best way to insert 100000 records in a table considering the performance issue.
i mean data should be added in the table with least possible time.
You need to use FORALL statement using PL/SQL.
use the insert with select clause and also use the append hint which is used for direct path insertions.
insert /*+ append */ into <tablename> select <query>;