Gathering statistics during index rebuild

posted Jan 28, 2012, 9:11 AM by Sachchida Ojha
You can gather statistics on an index while rebuilding the index.
SQL> alter index dbaref.emp_pk rebuild compute statistics;

index altered.

Note: you save time by having the database gather stats while it is rebuilding the index.