Index-Organized Tables

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 Devart - 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, from the shortcut menu.

Note

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