Creating a TEXT Index Using Sybase Central

Before you can perform a full text search, you must create a TEXT index on the columns you want to search.

A TEXT index stores positional information for terms in the indexed columns.

  1. Connect to the database as a user with DBA or RESOURCE authority.
  2. In the left pane, right-click the Text Indexes folder and select Text Index > New.
  3. Select the table on which to create the TEXT index.
  4. Type a name for the TEXT index. Click Next.
  5. Select the column to include in the index. Click Next.
  6. Select the text configuration object to use when processing the data for the TEXT index. Click Next.
  7. For SQL Anywhere tables, in the Specify a Refresh Type dialog, click Next.

    For Sybase IQ tables, this option does not appear. The only supported refresh type is Immediate.

  8. Select the dbspace where the TEXT index will be stored.
  9. Click Next.
  10. Type a comment describing the text configuration, and click Finish.
Parent topic: TEXT Indexes