Partitioning Catalogue

This is a list of all articles I’ve written about partitioning. Each entry has a date stamp and a short note of the contents. The articles are generally listed most-recent first.

The page also includes a link to a list of older articles from other authors on partitions and statistics.

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

On this blog

• Global Rowids (February 2023): a note describing how rowids are stored in global indexes
• Drop Partition (Aug 2022): the mechanics and cost of deferred global index maintenance
• Dropping tablespaces (July 2022): composite partitioning, LOBs, and reusing the names of dropped tablespaces can result in subsequente surprising errors.
• Splitting a big partition into little pieces (June 2021): a strategy to reduce and spread the workload.
• Partitioning existing data – prep work (May 2021): a couple of details that you might want to clean up first (unused columns, fast add default).
• Interval partition predicate oddity (Oct 2020): Interval partitioning leaves in predicates that “normal” range partitioning can remove.
• Interval partition serialising (Feb 2020): Why did a parallel insert into an interval partitioned table serialise through one PX process – conjecture and workaround.
• Dropping anchor for interval partitions (Mar 2018): What happens (internally) to interval partitions when you start to drop or merge the low ones.
• Interval Partitioning load threat (Feb 2018): a big insert as select, create as select to load/create an interval partitioned table can produce a MASSIVE sort.
• Interval limits and error messages (Feb 2016): You can have 2²⁰ – 1 segments in a partitioned table so plan your interval size and subpartition count carefully.

Other Authors

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