--
gather table stats
exec dbms_stats.
gather_table_stats(ownname =>'your schema name',
tabname =>'your table name',
estimate_percent=>100,
method_opt =>'FOR TABLE',
cascade =>TRUE);
--gather index stats
exec dbms_stats.gather_index_stats(ownname =>'