Script for gathering index stats

set head off
spool dbmsidx.sql
select 'prompt gathering statistics of index '||owner||'.'||index_name,
'exec dbms_stats.gather_index_stats('||chr(39)||owner||chr(39)||','||chr(39)||index_name||chr(39)||');'
from dba_indexes where owner in ('')
order by owner,table_name;
spool off