|
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,
 |
 |
 |
 |
 |
 |
1. Connect to
Server
|
2. Right Click
Database Indexes |
or Right Click
Table Indexes |
3. Enter Index
Properties |
4. Preview SQL
|
Sample Index |
ALTER
Right clicking on an Index in the Scheam Browser allows it to be
ALTERed.
DROP
Visual Editing tools allow Indexes to be dropped through a right
click in the schema browser.
|
