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

Niciun comentariu:

Trimiteți un comentariu