Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dipeshneema
Starting Member
6 Posts |
 Posted - 2010-12-02 : 05:01:06
|
| I am having a table with 5 million records. I have fields (Title,AuthorList) as fulltext columns.When I search uncommon words it gives results fast but when i used Contains((PRODUCT_TITLE,AuthorList ),'"john"') then it took more than 2 mins to return 200,000 records.How can i fast the search. |
|
|
|
|
|
Full text search is very slow