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.
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.
Use the SQL Anywhere 12 plug-in to connect to the database.
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 click New » Index.
Follow the instructions in the Create Index Wizard.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|