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.

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

  1. Connect to the database as a user with CREATE ANY INDEX or CREATE ANY OBJECT system privilege, or as the owner of the underlying table.
  2. Execute a CREATE TEXT INDEX statement.

This example creates a TEXT index, myTxtIdx, on the CompanyName column of the Customers table in the iqdemo database. The default_char text configuration object is used.

CREATE TEXT INDEX myTxtIdx ON Customers
	( CompanyName ) CONFIGURATION default_char
Parent topic: TEXT Index