Full Text Index

Full Text Indexes:

           

 Full text index are very helpful in searching for words that are embedded in the midlle of string fields . This information can be used by queries to run more efficiently and bring more accurate results. This index can also be used on MEMO and EDT's .

There Can be only one Full Text Index per table.

 

How To Create a Full Text Index:

• First we need to create a table and the table must contain string fields.
• Set the Table group property of the table to Main.
• Expand the table and right click on it's Full Text Index node and create new Full Text Index.
• Drag and drop the table's string fields on the newly created Full Text Index.

Your project should look like this.

    
   

Using Full Text Index In Queries:

In order to Use Full Text index in queries we need to create a simple job like this.

Hope it was helpful to you.....