Search Optimization
-
Hi all, I have one table in which there is a column named productDetail which has datatype varchar(8000). When i queried to this table, it takes lots of time to search. There is a 6 lac records in my table. I try to use Fulltext indexing, but it has some limitation for some words which it can not able to search as per my knowledge. I use SQL Server 2000. Is there any ways to make search more faster. :zzz: Thanks in advance...
Krishnraj
-
Hi all, I have one table in which there is a column named productDetail which has datatype varchar(8000). When i queried to this table, it takes lots of time to search. There is a 6 lac records in my table. I try to use Fulltext indexing, but it has some limitation for some words which it can not able to search as per my knowledge. I use SQL Server 2000. Is there any ways to make search more faster. :zzz: Thanks in advance...
Krishnraj
Fulltext indexing would be the correct way if you search for words.
Krishnraj wrote:
it has some limitation for some words which it can not able to search as per my knowledge
What kind of limitations? Full text search should be able to search for any exact words. If you want to search for a word in different forms, then it may have limitations.
The need to optimize rises from a bad design.My articles[^]
-
Fulltext indexing would be the correct way if you search for words.
Krishnraj wrote:
it has some limitation for some words which it can not able to search as per my knowledge
What kind of limitations? Full text search should be able to search for any exact words. If you want to search for a word in different forms, then it may have limitations.
The need to optimize rises from a bad design.My articles[^]
Hi mika, Thank for replying.. Few days ago i read somewhere in site that fulltext indexing can not search all words. that is why i wrote like this. so to search from fulltext indexed column i have to use Contain or something that kind of word. M i right? Actually i have no idea how to use it? so give some suggesion how to use it. Thank you again... :)
Krishnraj
-
Hi mika, Thank for replying.. Few days ago i read somewhere in site that fulltext indexing can not search all words. that is why i wrote like this. so to search from fulltext indexed column i have to use Contain or something that kind of word. M i right? Actually i have no idea how to use it? so give some suggesion how to use it. Thank you again... :)
Krishnraj
Krishnraj wrote:
so to search from fulltext indexed column i have to use Contain or something that kind of word. M i right?
Yes, see CONTAINS (Transact-SQL)[^] and FREETEXT (Transact-SQL)[^]
Krishnraj wrote:
Actually i have no idea how to use it? so give some suggesion how to use it.
On those documents there are several good sample queries. Have a look at them. Also remember that Full Text Indexing service must be running in order to use full text search.
The need to optimize rises from a bad design.My articles[^]
-
Krishnraj wrote:
so to search from fulltext indexed column i have to use Contain or something that kind of word. M i right?
Yes, see CONTAINS (Transact-SQL)[^] and FREETEXT (Transact-SQL)[^]
Krishnraj wrote:
Actually i have no idea how to use it? so give some suggesion how to use it.
On those documents there are several good sample queries. Have a look at them. Also remember that Full Text Indexing service must be running in order to use full text search.
The need to optimize rises from a bad design.My articles[^]