How_to_stop_gather_stats_after_index_rebuild

How to stop collecting index statistics during an index rebuild :

Oracle 10g, by default, collects statistics for an index during 

index creation.  It is done by design. 
The internal parameter "_optimizer_compute_index_stats", is set to

TRUE by default.



 alter session  set "_optimizer_compute_index_stats"=FALSE;
 

IN this case, the time for rebuilding the index is much lower : 

15% faster for an index rebuild