Statistics catalogue

This is a list of all articles I’ve written that talk about statistics, with a date stamp and short note of the contents. I have also created a couple of sub-catalogues around major topics:

• Column Groups catalogue
• Histograms catalogue
• Partition Stats catalogue (other authors 2007 – 2012)

I am currently working backwards through my entire blog adding articles to catalogues as I go, so any individual catalogue may grow very slowly.

• 19c – better stats (April 2022): Oracle now uses approx_count_distinct() on the whole index in dbms_stats.gather_index_stats().
• system_stats() hint – Jan 2022: notes on a hint that allows you to set the “noworkload” system statistics in a hint on Exadata.
• Optimizer Tip – Sept 2021: reprint of a note for IOUG 2015 on column groups and table_cached_blocks
• Stats preferences – Aug 2021: a simple query to report all the system and table preferences, default or explicitly set
• Using the num_index_keys() hint (Nov 2018)
• Minimum Stats (Sept 2012): auto_sample_size on an index tends to mean 1,140 blocks

Other Authors

• Partition Stats (2007 – 2012) – a list of articles written by other people on the topic of staitistics on partitioned objects.
•