Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Query and modify data » Full text search » Full text search tasks


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.


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.


The text index is created.



 See also