Set full-text indexing service for MicrosoftSQLServer7.0 _ MySQL-mysql tutorial

The Full-Text Search Service (Full-Text Search Service) is provided in Microsoft SQL Server 7.0. in terms of query performance, for varchar, char, text fields are more than 10 times faster than the Like operator and match operator in SQL statements, fuzzy match provides advanced search performance and returns the hit rate of the query.

Full Text Search Service is included in SQL Server 7.0 and does not work in SQL Server 7 Destop. When installing SQL server, you cannot install it by default. you must select it in Custom Installation.

After the service is installed, Full-text Search is displayed in Support Services in SQL Server EnterPrise Manager, and Microsoft Search is displayed in Services in the control panel. you can start this service in SQL Server EnterPrise Manager to add full-text indexes to the table.

Note: only a table with a unique index column can create a full-text index. after the full-text index is created, the table cannot be changed. to change the table, you must retrieve the index and load it.

Follow these steps to set a full-text index for a table:

1. select the Table for which you want to create a Full-Text Index, and then select: Full-Text Index table-> Define Full-Text Indexing on a Table

2. the system starts the SQL Server Full-Text Index wizard.

3. select a unique index.

4. select a field to be indexed.

5. select catalog.

6. select to update the index plan (because full-text indexes are different from normal index tables and cannot be automatically updated, you must add a plan ).

7. Finish

8. select the newly created catalog in the database Full-text catalogs, and run Start Population and Full Population.