Creating an index

You can create indexes on base tables or temporary tables, but you cannot create an index on a view. 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. You can use the Index Consultant to guide you in a proper selection of indexes for your database.

Prerequisites

You must have DBA authority or be the owner of the table.

Context and remarks

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.

 Create an index using Sybase Central

  1. Use the SQL Anywhere 12 plug-in to connect to the database.

  2. In the left pane, double-click Tables and select the table for which you want to create an index.

  3. In the right pane, click the Indexes tab.

  4. In the left pane, right-click the table and click New » Index.

  5. Follow the instructions in the Create Index Wizard.

Results

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

Next

None.

 See also
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1