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 |
GerardIII
Starting Member
1 Post |
Posted - 2012-11-12 : 08:50:43
|
Hi, I am using a query with the containstable function, with a string search like this: "1-1" or similarThe issue is that the query takes way too long and doesnt bring many results.Instead the same query, but with other search string like "a" which retrieve much more results, take much less time to complete.this is the query:select count(d.DocumentID)from KnowledgeIndex_Data.dbo.Document dINNER JOIN CONTAINSTABLE ( KnowledgeIndex_Data.dbo.Document , * , '"1-1"' ) ftt ON ( d.DocumentID = ftt.[Key] ) Do you know what could be going on?Thanks! |
|
|
|
|