|
GerardIII
Starting Member
Uruguay
1 Posts |
 Posted - 11/12/2012 : 08:50:43
|
Hi, I am using a query with the containstable function, with a string search like this: "1-1" or similar
The 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 d
INNER JOIN CONTAINSTABLE ( KnowledgeIndex_Data.dbo.Document , * , '"1-1"' ) ftt ON ( d.DocumentID = ftt.[Key] )
Do you know what could be going on?
Thanks! |
|
CONTAINSTABLE performance with "1-1" searches
