statistics on global indexes not getting collected automatically
768687Apr 23 2010 — edited Apr 23 2010There is a partitioned table, which has 2 local indexes and 3 global indexes. By the auto gather_stats job, the global indexes are getting analyzed during the scheduler window every night, but the global indexes are not getting gathered.
When checked, the statistics on the indexes are stale, even then stats not getting gathered on them.
Please can someone help on how can i figure out why the stats job is skipping the global indexes.
Thanks in advance,
Tasneem