SQLSERVER full-text search

Before reading this article, please first read the MSDN documents that I excerpted below for full-text search, basically, I copied all the information about full-text search on MSDN and carefully read and tested it once, and added some SQL statements, in this article, I have extracted some of my self-defined key points and added myself

Before reading this article, please first read the MSDN documents that I excerpted below for full-text search, basically, I copied all the information about full-text search on MSDN and carefully read and tested it once, and added some SQL statements, in this article, I have extracted some of my self-defined key points and added myself

SQLSERVER full-text search

Before reading this article, please take a look at the MSDN documents that I have excerpted for full-text search below. Basically, I have copied all the information about full-text search on MSDN.

I carefully read and tested the Hong Kong server and added some SQL statements. In this article, I have extracted some of my self-thought key points.

I also added some of my own content, the Hong Kong Space, and added and sorted out the full-text search information on the Internet that was not found on MSDN.

For the full-text search performance, you can refer to the articles I copied.

Article address:

In another article on the internet, full-text search is also detailed.

SQL Server full-text directory address:

As for what full-text search is, I will not talk about it. There are a lot of online articles, but these articles are incomplete in summary and induction. I just set up the full-text index, but they haven't gone into depth or I have to sort it out.

(V = SQL .105). aspx
(V = SQL .105). aspx

Full-text search Architecture

First go to an image of MSDN

I drew a simple figure.

In fact, full-text search technology is also called full-text search or full-text index, but I think it is correct for both methods.

Differences between common SQLSERVER and full-text indexes in MSDN

Full-text index

Common SQL Server Indexes

Each table can have only one full-text index.

Each table can have multiple common indexes.

Population, can be requested through either a schedule or a specific request, or can occur automatically with the addition of new data. "data-guid =" 16d49fbbe94c83e4bf994c864a469764 "> adding data to a full-text index is called" filling ". You can request filling by planning or specific requests, it can also be automatically filled when new data is added.

The data is automatically updated when it is inserted, updated, or deleted as its basic data.

Groups one or more full-text directories in the same database.

Do not group.

After a full-text index is created in a table, you will not see the full-text index page in the data table, because MSDN makes it clear,

Because full-text index rows are stored in the file system of the disk in a compressed format to optimize disk usage, and the data is stored in binary data.

When you create a full-text directory, you can select a directory location where the full-text index is stored.

When you query full-text index columns, SQLSERVER will scan the full-text directory on the Hong Kong virtual host to find the records you need to query, so when you view the execution plan, you will see an execution plan "remote scan"

Remote scanning accounts for a majority

Full-text search with full SQL

I have seen many articles on the Internet that use SSMS to create full-text indexes. I want to use full SQL to create full-text indexes. Because most experts use TSQL instead of GUI, although I am not a master o (beats _ beats) o

(1) create a folder fulltext on drive D.

You can create a full-text index in either of the following ways:

..., N