analyze table compute statistics.
you might look at dbms_stats.gather_table_stats as a better alternative.