Sure... select companyName, companyState from companyDetails where freetext(companyName, '"eagle*"') and companyState = 'WA' order by companyName
Returns 121 rows in 2 seconds While... select companyName, companyState from companyDetails where companyNamelike '%eagle%' and companyState = 'WA' order by companyName Return 149 rows in 25 seconds So the performance increase is there, but the results aren't what I was expecting. My impression is that the full-text search looks for the word 'eagle' and a few variations like 'eagles' but does not pick up versions such as 'eaglehawk'. Thanks, Brett B) Taco Fleur wrote: > Can you post your SQL? > > On 7/6/07, *Brett Payne-Rhodes* <[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]>> wrote: > > > I'm trying to speed up a wildcard search on a text field along the > lines of SELECT companyName from companyDetails where companyName > like '%eagle%' > > The database is mssql 2005 and the table has over two million rows. > > What I have already done is to create a full-text index on > companyName and while it does appear to run faster, the results > generated by the query using the full-text index aren't even nearly > the same as the results of the wildcard query in that the wildcard > search picks up 'eaglehawk' but the full-text query doesn't, even > using "eagle*". > > Can anyone explain this for me or point me to a reference that will > help? > > Thanks and sorry for the OT but I thought other people here might be > interested. > > Brett > B) > > > http://www.clickfind.com.au > The new Australian search engine for businesses, products and services > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
