IOTs

That’s index organized tables, of course. Searching back through my blog I find that I’ve only written one article 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.

• Part 1: The basics
• Part 2: Examples and Proofs
• Part 3: Greatly reduced I/O
• Part 4: Boosting buffer cache efficiency
• Part 5: Primary Key issues
• Part 6a: Inserts and upates slowed down
• Part 6b: OLTP inserts into an IOT