--- In firebird-support@yahoogroups.com, "markd_mms" <spam@...> wrote:

>
> --- In firebird-support@yahoogroups.com, "markd_mms" <spam@> wrote:
> > i tried different conditions like =, LIKE, CONTAINING but it didn't
> > seem to make a difference.
>
> although i just tried STARTS WITH and it doesn't seem to slow the
> query down.
>
> mark
>

Two questions:

1) Why do you need the OR condition?

If anything is guaranteed to match a soundex, it is an identical
string. Just seems like extra work with no benefit to me.

2) How would it be possible to use an index on title to solve
a 'containing' or 'like' query?

Although I am surprised you did not have more luck with '='.

Adam