Can you post your SQL?
On 7/6/07, Brett Payne-Rhodes <[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
-~----------~----~----~----~------~----~------~--~---
