SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to enable and disable indexes in oracle?

527542Feb 25 2007 — edited Feb 26 2007

Hi,

I am using Oracle 10G.
Could you please explain me how to enable or disable indexes on a table?

My scenario is as follows.

I am inserting millions of records in target tables. To increase performace, before inserting data into the tables, I would like to disable indexes. AFter the process is completed and I would like to re enable the indexes.

Does it a good pracitce? Am I going in a right way.

Any suggestions are welcome.

Thank you,
Regards,

Gowtham Sen.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 26 2007

Added on Feb 25 2007

16 comments

3,595 views