Creating and Maintaining the Text Indexes

Before the Full-Text Search engine can process full-text searches, you must create text indexes for the source tables in the user database. After the text indexes are created, you must update them when the source data changes to keep the text indexes current. To create and maintain the text indexes:

For an example of setting up a text index, see the sample script sample_text_main.sql in the $SYBASE/$SYBASE_FTS/sample/scripts directory.