Do not use the old ANALYZE TABLE or ANALYZE INDEX to generate optimizer statistics anymore. The DBMS_STATS package does a much better job and it has more features.
Dig deeper on Using Oracle PL-SQL
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.