A heap-table stores the rows in an unordered fashion. Index-organized tables and clustered indexes are the alternative. They store the rows in an ordered B-Tree structure.
Book-Section: Index-Organized Tables
Glossary: Clustered Index — Table stored in a B-Tree index
Glossary: Index-Organized Table — Oracle Clustered Index
Table of Contents
Training and Coaching
Expert, competent, or just a greenhorn? Test your SQL performance skills in just three minutes. ›
by Markus Winand.
Visit our sister site!
A lot has changed since SQL-92