Perrin Harkins schrieb:
> 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.

IMHO not in this case, cause it is just a simple "WHERE field IN ()"

--
Sebastian Mendel