On Wed, Apr 23, 2008 at 9:22 PM, D Hill <d.hill@yournetplus.com> wrote:
> Can anyone shed some light if I should index wite_desc to speed things up?

No, since you don't use that column at all. If you're not on MySQL 5,
upgrading to MySQL 5 will help. Otherwise, you're best bet is to
rewrite the query as UNION clauses with one of your WHERE conditions
in each. I know it sounds crazy, but before MySQL 5 the use of
indexes with OR queries was not very good.

- Perrin