If I run ANALYZE TABLE table_name COMPUTE STATISTICS;
am I analyzing indexes also?...how about indexed columns?
or do I need to run following command along with the first one?
ANALYZE TABLE table_name COMPUTE STATISTICS FOR ALL INDEXES
ANALYZE TABLE table_name COMPUTE STATISTICS FOR ALL INDEXED COLUMNS
If I want to have complete analyze on tables, indexes, and etc.... which command should I use?