To
create a Signature Text Index:
Click the Signature Text Index object in the tree. The Properties page appears.

Click Create. The Introduction window for the Create Signature Text Index Wizard is displayed.
Click Next. The Name the signature text index window is displayed.

Select the name of the table from which the text index is to be created from the Table Name menu.
Enter the name of the text index in the Text Index Name field.
A list of available columns on the selected table appears on the left hand list box. Select the columns that you want to use in the signature text index by double clicking on the column name or selecting the column and clicking the Add button. The Add all button can be used to add all columns to the index. All the columns selected for the creation of the text index will be displayed in the list box to the right. Columns in the text index can be likewise removed by double clicking on the column name or selecting the column and clicking the Remove button.
Click Next. The Advanced Settings window will open.

To change the signature text index settings:
To change the total text size, enter a value into Total Text Size between 1 and 200.
To change the scale, enter a value into the Scale field between 10 and 200.
To present data as it relates to another column in the table select the Use order-by feature check box.
Select the column that the text index will follow the order of from the Order Column menu.
Select the Ascending option button to order data in the text index by the Order Column's ascending order.
Select the Descending option button to order data in the text index by the Order Column's descending order.
Click Next. The Final review window will open.

To alter the SQL script, enter new script into the Create Text Index SQL script field or click Previous to display the previous screens in the wizard.
To complete the signature text index creation after reviewing the SQL script, click Finish. The Information dialog box is displayed.

Click OK.
Related topic: