Creating indexes

Indexes are created on one or more columns of a specified table. You can create indexes on base tables or temporary tables, but you cannot create an index on a view. To create an individual index, you can use either Sybase Central or Interactive SQL. You can use the Index Consultant to guide you in a proper selection of indexes for your database.

When creating indexes, the order in which you specify the columns becomes the order in which the columns appear in the index. Duplicate references to column names in the index definition is not allowed.

To create a new index (Sybase Central)

Connect to the database as a user with DBA authority.
In the left pane, double-click Tables and select the table for which you want to create an index.
In the right pane, click the Indexes tab.
In the left pane, right-click the table and choose New » Index.
Follow the instructions in the Create Index Wizard.

The new index appears on the Index tab for the table. It also appears in Indexes.

To create a new index (SQL)

Connect to the database as a user with DBA authority, or as the owner of the table on you are creating the index.
Execute a CREATE INDEX statement.

In addition to creating indexes on one or more columns in a table, you can create indexes on a built-in function using a computed column. See CREATE INDEX statement.

Example

The following example creates an index called EmployeeNames on the Employees table, using the Surname and GivenName columns:

CREATE INDEX EmployeeNames
ON Employees (Surname, GivenName);

See CREATE INDEX statement, and Monitoring and improving performance.

Send feedback about this page via email or DocCommentXchange