Error - DRG-51030: wildcard query expansion resulted in too many terms
Hi All,
My searches against a 100 million company names table on org names often result in the following error:
DRG-51030: wildcard query expansion resulted in too many terms
A sample query would be:
select v.* --xref.external_ref_party_id,v.*
from xxx_org_search_x_v vwhere 1 =1
and state_province = 'PA'
and country = 'US'
and city = 'BRYN MAWR'
and catsearch(org_name,'BRYN MAWR AUTO*','CITY=''BRYN MAWR''' ) > 0
I understand that is caused by the presence of the word Auto to which we append a * . (If i remove the auto the search works fine).
My question is - is there a way to limit the query expansion to only , say 100, results that get returned from the index?