I believe oracle 11g uses statistics for optimization of queries. And statistics are collected by
invoking the package dbms_stats.
My question is, If the statistics are not collected by dbms_stats, will oracle collect
any statistics by its own after a period of time?
What are the statistics data used by the optimizer?
What is the difference between table_stats and index_stats?