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. See Data type conversions.

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.

To create a text index (Sybase Central)

1. Connect to the database as a user with DBA authority, or as the owner of the table on which you are creating the text index.

2. Click the Text Indexes tab.

3. Choose 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 choosing Refresh Data.

To create a new text index (SQL)

1. Connect to the database as a user with DBA authority, or as the owner of the table on which you are creating the text index.

2. Execute a CREATE TEXT INDEX statement. See CREATE TEXT INDEX statement.

3. 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 executing a REFRESH TEXT INDEX statement. See REFRESH TEXT INDEX statement.

See also

• Text index refresh types
• Full text searching