Oracle Database Discussions

Hi,

I am inserting about 10 millions rows into a table, wich having 3 types of indexes :
functioanal base, bitmap and normal.

Now to speed up the insert I am thinkig of disabling the indexes, but not really sure which
solution would be better:

Solution 1:
- disable indexes
- INSERT
- enable indexes
- dbms_stats.gather_index_stats(...

Solution 2:
- drop indexes
- INSERT
- CREATE INDEX...
- dbms_stats.gather_index_stats();

Solution 3:

- ALTER INDEX <index_name> UNUSABLE;
- INSERT
- ALTER INDEX bix_gender REBUILD;
- dbms_stats.gather_index_stats();

One more thing...

Is this correct, that DISABLE applies to a function-based index only???

Thanks!!!