SQL Server full-text indexing

Reading less, the first contact with this concept, think very interesting, take to summarize.

So what is a full-text index?

Let's explain what the index is. indexes, using indexes to quickly access specific information in a database table. An index is a structure that sorts the values of one or more columns in a database table.

With an index, you can improve efficiency when you query. There is no doubt that full-text indexing is also to improve the efficiency of queries, then what is the difference between them?

For example, a structure similar to:

You set up the index in the Newstitle column, then you query where newstitle= ' interesting news headlines 1 ' will improve efficiency. So what about the index?

The query title contains the keyword "news" or "haha" and other phrases when playing a role!

So how do you build a full-text index?

1. Create a new full-text catalog

I'm going to call Fulltext here.

2. Create a new full-text index on the t_news on the table

3. Then continue to the next step, select the index column you want to add.

5. Then complete the next step.

Let's see what happens next.

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

SQL Server full-text indexing