Index-Organized Tables

Last modified: October 23, 2019

An index-organized table (IOT) is a type of table that stores data in a B*Tree index structure.

Creating an Index-Organized Table

1. Click the New Database Object button on the Standard toolbar.
2. Select the Table type in the dialog.
3. Input the table name.
4. Add columns to the table.
5. Click Index Organized.
6. Go to the IOT tab.
7. Set required index-organized parameters.
8. Save the document.

To drop an index-organized table, select a required table, and then select Delete on the shortcut menu.

Note

While dropping a table, all its data will be lost.