Re: Disable Keys/Enable Keys
Maybe it is better not the disable keys when you have lots of records in the table already.
When you enable keys, it will have to rebuilt the whole index including the existing records, not just the newly inserted records, since it does not know which records are newly inserted.
Maybe you should increase the bulk_insert_buffer_size
Subject
Views
Written By
Posted
26979
February 08, 2006 10:30AM
Re: Disable Keys/Enable Keys
15608
February 08, 2006 07:28PM
10275
February 09, 2006 03:30AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.