Column Group Catalog

I seem to have written a number of aricles about column groups – the rather special, and most useful, variant on extended stats. To make it as easy as possible to find the right article I’ve decided to produce a little catalogue (catalog) of all the relevant articles, with a little note about the topic each article covers. Some of the articles will link to others in the list, and there are a few items in the list from other blogs. There are also a few items which are the titles of drafts which have been hanging around for the last few years.

• Column group histograms (Aug 2018): Formal coding method
• Column group histograms (Jul 2018): Hacking to solve a problem
• Column groups (Mar 2018): A “cosmetic” change to a query makes increased use of column groups possible.
• Index out of range (Mar 2017): Effects of “out of range” predicates on indexes and column groups
• Extended Stats (Dec 2016): A dirty workaround to the limited number of column groups allowed.
• Adaptive Mayhem (Aug 2016): The anguish of 12.1 and adaptive statistics.
• Index Sanity (June 2016): A very old demonstration – don’t drop an index just because you’re not using it.
• Column groups (Apr 2016): A bug
• Automatic column groups (Dec 2015): A threat due to upgrading to 12.1
• Upgrades (Dec 2015): A summary of a round-table CBO session that covered column groups and virtual columns
• Column groups (Dec 2015): A problem with column groups and char() types.
• Column groups (Nov 2015): A predicate “column is null” will disable the use of any related column groups.
• Extendend Stats (May 2014): Under the covers with column groups.
• Extended Stats (Sep 2013): How a typo could introduce extra column groups
• Extended Stats (April 2012): The stats on a column group will not be used if a predicate on an underlying column queries values outside the low/high range
• Index Upgrades (Mar 2012): the optimizer can use distinct_keys from indexes can be used in the same way it uses column group stats
• Correlation Strength (draft):
• The optimizer’s inconsistent Use of column groups (draft):
• Case study: Dropping indexes (draft):
• Column groups – a bug (draft):
  
• col_usage$ (draft)
• Excessive Parsing (Nenad Noveljic):
• Column Group bypassed (Chris Antognini): The “histogram” problem of column groups, reporting a known bug number and fix_control to address the issue.
• ORA-20008: Number of extensions … (Iordan Iotzov):  Getting the best from a limited number of column groups.