IOTs (Index Organized Tables)
GPTKB entity
Statements (20)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
database object
|
| gptkbp:alternativeTo |
heap-organized tables
|
| gptkbp:benefit |
reduced storage requirements
faster access for primary key queries |
| gptkbp:documentation |
Oracle Database Concepts Guide
|
| gptkbp:excludes |
separate heap table
|
| https://www.w3.org/2000/01/rdf-schema#label |
IOTs (Index Organized Tables)
|
| gptkbp:introducedIn |
gptkb:Oracle8i
|
| gptkbp:limitation |
row overflow for large rows
slower for full table scans |
| gptkbp:numberOfLocations |
table rows in index leaf blocks
|
| gptkbp:primaryKey |
used as row identifier
|
| gptkbp:storage |
in a B-tree index structure
|
| gptkbp:supports |
compression
partitioning secondary indexes |
| gptkbp:usedFor |
applications with frequent primary key lookups
|
| gptkbp:usedIn |
gptkb:Oracle_Database
|
| gptkbp:bfsParent |
gptkb:Flashback_Table
|
| gptkbp:bfsLayer |
8
|