Oracle Scratchpad

November 22, 2011


Filed under: Infrastructure,IOT,Oracle — Jonathan Lewis @ 9:51 am GMT Nov 22,2011

Updated 2021 with a catalogue of articles that I’ve written about IOTs since I first posted this note.

That’s Index Organized Tables, of course. Searching back through my blog I find that I’ve only written a couple of articles about IOTs although I’m very keen on taking advantage of them and have made a few references to them in other articles. Rather than addressing this oversight myself, I thought I’d direct you to a series on IOTs by Martin Widlake.

Updated Feb 2014 with another worthwhile catalogue of articles

Richard Foote’s array of articles on IOTs

Update Feb 2021 – a catalogue of my own IOT articles in date order:







  1. Thanks for the mention Jonathan. I started the series partly because neither yourself or “the king of indexes” Richard Foote had blogged much about them. I think I might eventually get to post 10 or 12 on the subject…

    Comment by mwidlake — November 22, 2011 @ 10:02 am GMT Nov 22,2011 | Reply

    • Martin,

      I’ll be looking forward to reading the next lot.
      If you want to add a comment here each time you publish one I’ll add it to the list.

      Comment by Jonathan Lewis — November 23, 2011 @ 7:42 am GMT Nov 23,2011 | Reply

  2. Jonathan,

    thank you for adding the second list: now I finally have the one single link to answer all IOT questions I get.

    Comment by Martin Preiss — February 10, 2014 @ 9:23 pm GMT Feb 10,2014 | Reply

  3. […] PARTITION”. The last five lines report objects that are the physical instantiation of index organized tables (IOTs) so, although they are indexes and we can call gather_index_stats(), we would probably prefer […]

    Pingback by Stale Stats | Oracle Scratchpad — March 28, 2019 @ 9:00 am GMT Mar 28,2019 | Reply

  4. […] Index Organized Tables (IOT) catalogue (Blog notes 14, Other authors 15) […]

    Pingback by Catalog Catalogue | Oracle Scratchpad — April 20, 2022 @ 2:22 pm BST Apr 20,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: