What does the show statistics tell you?
Are there any defined user change or percent thresholds?
What about system wide settings for those?
The optimizer should skip recollection if some of those settings are set and not met.
Thanks David, My observation is that if there are no changes in the number of unique values in a column for a table, stats will not be updated (even if you collect stats on the whole table).