Creating a text index

You can create text indexes on columns of any type. Columns that are not of type VARCHAR or NVARCHAR are converted to strings during indexing.

Prerequisites

You must have DBA authority or be the owner of the table on which you are creating the text index.

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.

You cannot create a text index on a materialized view, a regular view, or a temporary table.

Do not create more than one text index referencing a column since this can return unexpected results.

 Create a text index (Sybase Central)

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

  2. Click the Text Indexes tab.

  3. Click File » New » Text Index.

  4. 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.

  5. If you created an immediate refresh text index, it is automatically populated with data. For other refresh types, you must refresh the text index by right-clicking it and clicking Refresh Data.

Results

The text index is created.

Next

None.

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