Hi, We are testing insert performance in one of out tables and we are selecting from 1 table 1000 rows at a time and inserting in 2nd table. So we were getting tps of about 17000 for 1 million records. Then I added append hint to insert and tps went up to 23000. Now if I a try to insert from 2 clients to increase scalibility both insert at tps of 11000. so I have 2 questions: 1) What is the disadvantage of adding append hint during insert (we never delete or update this table in production) 2) Will the hint applicable to all the indexes or only table 3) Why with 2 clients using append result in less tps than normal 2 client inserts? Thanks --Harvinder =20 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------