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
- Click the New Database Object button on the Standard toolbar.
- Select the Table type in the dialog.
- Input the table name.
- Add columns to the table.
- Click Index Organized.
- Go to the IOT tab.
- Set required index-organized parameters.
- 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.
Want to Find out More?
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for Oracle.
Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for Oracle?