August 6, 2008 at 10:29 pm
what is fulltex index? what is its use
August 7, 2008 at 1:48 am
Fulltext indexes are used when we would like to implement wide search, like finding Therasure/Word within the sentence.
E.G: Google Search/ in Job site you search the Job Description, Location, etc.
Full-text indexes are created on table, and defined on columns. the mandatory condition for implementing fulltext indexing is your table must have unnique column.
For architechture of full text index you can consider BOL.
When implemented FullText index data can be search by using FREETEXT, FREETEXTTABLE, CONTAINS, CONTAINSTABLE operator/func.
Consider BOL for breif information on this.
Abhijit - http://abhijitmore.wordpress.com
September 5, 2008 at 7:33 am
Full text is good for when you have searches with the wild card prior to any text. When this happens it causes SQL Server to do a full scan on the table instead of using the index.
For example, if you had an index on the LastName column, the following query would NOT use the index:
Select ...
From Table1
Where LastName Like '%d%
But, if you changed the Where clause it WOULD use the index
Where LastName Like 'd%' --Starts with a letter
This is where full-text indexing would be beneficial. But this also comes with a price - it will have an overall impact on performance so you need to determine if it's worth it.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply