Index-organized table

From Oracle FAQ

Jump to: navigation, search

An index-organized table (IOT) is a type of table where the data is stored in a B*Tree index structure.

Example

CREATE TABLE t1 (c1 NUMBER PRIMARY KEY, c2 VARCHAR2(30))
  ORGANIZATION INDEX;

Also see


Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #
Personal tools