Perrin Harkins schrieb:
On Wed, Apr 23, 2008 at 9:22 PM, D Hill <[EMAIL PROTECTED]> 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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
