I am using Oracle 10G.
I am trying 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.
Is this a good pracitce? Am I going about it in the right way?
Any suggestions are welcome.