Fastest Insert
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Fastest Insert

  1. #1
    Join Date
    Dec 2002
    Posts
    89

    Fastest Insert

    what will be the fastest way to insert 8000000 rows in a table

    create partition table with all constraints and indexes then import

    or
    create partition table then insert into from other table then create constraints ,indexes.

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Where are the rows now? Is it in a table or flat file or export dump?

  3. #3
    Join Date
    Dec 2002
    Posts
    89
    in a table

  4. #4
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Assume Table T1 has data, and you want to move to T2.
    Here is what I will do:

    Disable all indexes or drop.

    alter table t2 nologging ;

    alter session force parallel dml parallel 6;

    alter session force parallel query parallel 6;

    insert /*+ append */ into t2 NOLOGGING select * from t1;

    commit;

    alter table t2 logging;

    Create/Rebuild all indexes.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width