HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

What is the use of creating full text catalog in full text indexing

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
thefullwhatcreatingindexingtextcataloguse

Problem

Just want to know about the processes happening in full text indexing. I know by defining the full text indexing for a table, it will index all the words saved in that table.

But i didn't get the use of creating a catalog for a full text index. And how an index related to catalog. Simply what the full text catalog will do in full text indexing.

Solution

From BOL:

After columns have been added to a full-text index, users and applications can run full-text queries on the text in the columns. These queries can search for any of the following:

  • One or more specific words or phrases (simple term)



  • A word or a phrase where the words begin with specified text (prefix


term)

  • Inflectional forms of a specific word (generation term)



  • A word or phrase close to another word or phrase (proximity term)



  • Synonymous forms of a specific word (thesaurus)



  • Words or phrases using weighted values (weighted term)



A full-text catalog is a logical concept that refers to a group of full-text indexes. Catalogs makes it easier for maintaining full text indexes.

Context

StackExchange Database Administrators Q#16462, answer score: 4

Revisions (0)

No revisions yet.