well you can either export index stats (use dbms_stats.EXPORT_INDEX_STATS) before rebuild then import back (dbms_stats.IMPORT_INDEX_STATS) which takes seconds of time or rebuild with estimate or compute statistics clause
alter index emp_pk rebuild compute statistics;




Reply With Quote