Create text indexes on columns of any type. Columns that are not of type VARCHAR or NVARCHAR are converted to strings during indexing.
To create a text index on a table, you must be the owner of the table or have one of the following privileges:
To create a text index on a materialized view, you must be the owner of the materialized view or have one of the following privileges:
You cannot create a text index when there are cursors opened with the WITH HOLD clause that use either statement or transaction snapshots.
You cannot create a text index on a regular view or a temporary table. You cannot create a text index on a materialized view that is disabled.
Context and remarks
Text indexes consume disk space and need to be refreshed. Create them only on the columns that are required to support your queries.
Creating more than one text index referencing a column can return unexpected results.
In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.
Click the Text Indexes tab.
Click File » New » Text Index.
Follow the instructions in the Create Index Wizard.
The new text index appears on the Text Indexes tab. It also appears in the Text Indexes folder.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|