Oracle Scratchpad

September 27, 2018

Column Group Catalogue

Filed under: CBO,Column groups,Indexing,Oracle,Statistics — Jonathan Lewis @ 5:16 pm BST Sep 27,2018

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.

Other Authors:


  1. […] Jonathan Lewis writes about Column Group Catalog. […]

    Pingback by Log Buffer #555: A Carnival of the Vanities for DBAs | Official Pythian® Blog — October 19, 2018 @ 7:18 am BST Oct 19,2018 | Reply

  2. […] might help increase the table’s cardinality estimate is to create extended statistics on the column group (puser, […]

    Pingback by Execution Plans | Oracle Scratchpad — July 9, 2020 @ 4:54 pm BST Jul 9,2020 | Reply

  3. […] side effects even for cases where you don’t use this “is null” predicate. (More articles here about column […]

    Pingback by Optimizer Tip | Oracle Scratchpad — December 7, 2021 @ 12:50 pm GMT Dec 7,2021 | Reply

  4. […] Column Group catalogue […]

    Pingback by Catalog Catalogue | Oracle Scratchpad — January 25, 2022 @ 12:22 pm GMT Jan 25,2022 | Reply

  5. […] Column Groups catalogue […]

    Pingback by Statistics catalogue | Oracle Scratchpad — February 21, 2022 @ 10:49 am GMT Feb 21,2022 | Reply

RSS feed for comments on this post. TrackBack URI

Comments and related questions are welcome.

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Website Powered by

%d bloggers like this: