Index-only tables
In some cases, all the data that would normally be stored in a table can be stored in an index, and the table is not necessary. An index-only table, available starting with Oracle8, keeps the data sorted according to the primary key column. There are some limitations to this type of object:
Since the data is not stored in a table, there are no ROWIDs available.
A primary key must be defined for the table.
No additional indexes can be created; only the primary key may be indexed.
An index-only table is created by using the ORGANIZATION INDEX clause of the CREATE TABLE command.
Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.