Creating Indexes

Aqua Data Studio provides visual editors for creating and editing database Index objects.

An index contains keys created from one or more columns in a table, or view, and pointers that link to the storage destination of the data. A database index is a data structure that improves the speed of operations on a database table. Indices can be created using one or more columns of a database table, providing the basis for both rapid random lookups and efficient access of ordered records. By navigating the schema browser you may locate the Indexes Container of a database or schema table. Expanding the Indexes container (either for the database or database table), then expanding its columns container in the Schema Browser reveals the columns that make up the index. When an index exists for a table, the index appears in the ER Modeler if the database is imported into an ER Model.

To create an Index, right-click on the Indexes container for a database (or database table) and select Create Index. The resulting Create Index window allows for naming the index, selecting the index's schema, choosing its table columns, and setting index options. The options available when creating an index vary based on database vendor and version. The Sequence and Order (Ascending or Descending) of the selected columns is set within the Indexed Columns pane by clicking on them. the Preview SQL tab displays the DDL generated to create the Index. Once an index is created,

ALTER

Right-clicking on an Index in the Schema Browser allows it to be altered.

DROP

Visual Editing tools allow Indexes to be dropped through a right-click in the schema browser.