An index-organized table has a storage organization that is a variant of a primary B-tree. Unlike an ordinary (heap-organized) table whose data is stored as an unordered collection (heap), data for an ...

There are two basic types of partitioned index. Local - All index entries in a single partition will correspond to a single table partition (equipartitioned). They are created with the LOCAL keyword ...

Instead, an online utility can be used to lazily fix the invalid guess-DBAs. This scheme has been used to implement B/sup +/-tree indexes for Oracle8i index-organized tables (primary B/sup +/-tree ...