Online Documentation for SQL Manager for Oracle
Indexes
An index is a schema object that contains an entry for each value that appears in the indexed column(s) of the table or cluster and provides direct, fast access to rows.
Index Editor allows you to define index properties. It opens automatically when you create a new index and is available on editing an existing one.
To open an index in Index Editor, double-click it in the DB Explorer tree.
- Using Navigation bar and Toolbar
- Creating/editing index
- Partitions
- Setting storage attributes
- Browsing object dependencies
- Viewing DDL definition
