Index Organized Tables
March 25, 2005
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.
|
