TEXT Indexes

In a full text search, a TEXT index is searched, rather than table rows.

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. Queries that use TEXT indexes are generally faster than those that must scan all the values in the table.

When you create a TEXT index, you can specify which text configuration object to use when creating and refreshing the TEXT index. A text configuration object contains settings that affect how an index is built. If you do not specify a text configuration object, the database server uses a default configuration object.

You can create TEXT indexes on these types of columns: CHAR, VARCHAR, and LONG VARCHAR, as well as BINARY, VARBINARY, and LONG BINARY. BINARY, VARBINARY, and LONG BINARY columns require that the TEXT index use a text configuration with an external prefilter library.

• Comparison of WD and TEXT Indexes
  A comparison of WD and TEXT indexes in terms of syntax and capability.
• Creating a TEXT Index Using Interactive SQL
  Before you can perform a full text search, you must create a TEXT index on the columns you want to search.
• Guidelines for TEXT Index Size Estimation
  Formula estimates TEXT index main store size.
• TEXT Index Restrictions
  Text configuration objects and TEXT indexes have limitations by design.
• Displaying a List of TEXT Indexes Using Interactive SQL
  View a list of all the TEXT indexes in the database.
• Editing a TEXT Index Using Interactive SQL
  Change the settings for the TEXT index, including the dbspace and TEXT index name.
• Modifying the TEXT Index Location Using Interactive SQL
  Change the dbspace where the TEXT index is stored.
• Dropping a TEXT Index Using Interactive SQL
  Drop a TEXT index from the database.
• TEXT Index Refresh
  The only supported refresh type for TEXT indexes on SAP Sybase IQ tables is Immediate Refresh, which occurs when data in the underlying table changes.
• TEXT_DELETE_METHOD Database Option
  Specifies the algorithm used during a delete in a TEXT index.