Oracle Scratchpad

January 20, 2022

Indexing Catalogue

Filed under: Oracle — Jonathan Lewis @ 1:07 pm GMT Jan 20,2022

This is a list of all articles I’ve written that talk about indexes and indexing strategy. Each entry has a date stamp and a short note of the contents. The articles are (will be) grouped in a couple of different categories, but otherwise are generally listed most-recent first.

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

Engineering Indexes

  • 19c – better stats (April 2022): Oracle now uses approx_count_distinct() on the whole index in dbms_stats.gather_index_stats().
  • Generated predicates (March 2022): virtual columns from “function-based” indexes may allow the optimizer to generate predicates that you weren’t expecting to see.
  • Index ITL Limits (Feb 2022): stressing an index to the point of raising an error
  • OER_06051 (Jan 2022): How large can the blevel of an index get
  • Names matter (Nov 2021): renaming an index can change an execution plan
  • Function based indexes (July 2021): excellent use case, plus risk warning
  • num_index_keys() hint (Nov 2018): how to use it

1 Comment »

  1. […] Indexing catalogue […]

    Pingback by Catalog Catalogue | Oracle Scratchpad — January 28, 2022 @ 3:38 pm GMT Jan 28,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:

WordPress.com Logo

You are commenting using your WordPress.com 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 WordPress.com.

%d bloggers like this: