The "analyze table" is obsolete (from Oracle 7), and Oracle recommends that you always use dbms_stats. Your can save and re-use statistics with the dbms_stats.export_schema_stats procedure. If statistics are in place, Oracle will use them unless you have optimizer_mode=rule.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.