Clustered Tables
Clustered tables which belong to the same cluster store their data rows, having the same cluster key values together. Storage options of clustered table are defined by cluster, so you cannot modify them. Disc I/O is reduced and access time is improved for joins of clustered tables.
Creating a Clustered Table
- Click the New Database Object button on the Standard toolbar, and specify an object.
- Select the Table type in the dialog.
- Input the table name.
- Click Create. If specified table name is unique, the table editor appears.
- Add columns to the table.
- Optionally, you can alter the table name, change the database (owner), or set comment for the table.
- Click Clustered.
- Go to the Cluster tab.
- Select a schema and a cluster name that will contain the table.
- Select table columns that correspond to the cluster columns. You can select Create new column, and the required column will be created automatically.
- Save the document.
To drop a clustered 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?