Donald Burleson Click here for more Oracle News Headlines

Index Organized Tables 

Article Review

Indexed Organized Tables
By Scott Martin (smartin@tlingua.com) of Teralingua Software
IOUG SELECT Journal, First quarter 2005 (www.selectonline.org)

Author Scott Martin (with a Masters Degree from M.I.T. and a former member of the Oracle kernel group), has published a comprehensive article on Oracle index-organized table (IOT) technology, complete with clear examples and great conclusions.

Scott Martin has a great review of the IOT technology, when to use IOT, and what types of Oracle queries benefit the most from index-organized tables.  Martin provides examples and benchmarks and has several important conclusions about Oracle Indexed organized tables:

• Index organized tables with full-table scans:  “The IOT implementations would have taken 15x longer than the standard b-tree/table implementation.   . . . Applications which occasionally require a full table scan of their non-indexed columns may find Indexed Organized Tables (IOT) prohibitively expensive.”
   

• Index Range Scans:  “Queries that can be satisfied with an index range scans on Index organized tables (IOT) will perform significantly outperform the B-Tree/table model. . . . Notice the dramatic difference between 48 consistent gets with the B-tree/table versus the mere 3 consistent gets for the indexed organized table.”

Overall, this is an exceptional article and a definitive work for this author.