TurboDB VCL/CLX Component Library
Creating a Full-text Index at Design-time
See also
Previous  Top  Next


A full-text index is a data structure that enables you to find a record based on keywords in any column of the table very fast. TurboDB realizes this features by creating a helper table containing all the keywords and implementing a many-to-many relation between this keyword table and the original table.

To create a full-text index with TurboDB Viewer:
1.Open TurboDB Viewer. Usually it can be found in your Tools menu. The application is located in the bin subdirectory of your TurboDB installation folder.  
 
2.Open the table you want to create the full-text index for using the command DataSet/Open/Table...  
 
3.Open the full-text index wizard with Table/Full-text Index...  
 
4.On the first page select a name for the new helper table that will accept the keywords. Then enter a name for the keyword column within this table. The third item is the maximum length of the keywords. Keyword longer than this value will be cut.  
 
5.On the second page you can choose wich columns in the original table will be scanned. You may add all columns to the full-text index but very often you will add only a few fields.  
 
6.Since searching for words like and, in or a in a full-text index does not make much sense, you should try to eliminate those keywords form the full-text index. You can do this in two ways. First, you may decide to throw away keywords, which occur more often than a given limit, e.g. 100. Second, you can provide a text file that contains the words you don't want to be added to the full-text index. Both techniques will help to keep the full-text index small, will speed up searching and will avoid useless hits. The appropriate settings are done on the third page of the wizard.  
 
7.On the forth page of the wizard you are ready to create the full-text index. Since this action involves scanning all fields of all records in the table, it might take quite a time until completion.