Matt,
Thank you for the help and you are correct the index can't be utilized when using !=.
I will try
your hack/work around.
Thanks again.
sql,query
>Hi Heath,
>
>MySQL cannot use the trans_team query because you're using !=, for which
>an index is never used (currently anyway). Do you think
f the trans_team values ARE 'team oscar'.
Hope that helps.
Matt
- Original Message -
From: "heath boutwell"
Sent: Wednesday, October 08, 2003 3:15 PM
Subject: Innodb won't recognize index when optimizing query
> The query optimizer will not recognize an ind
The query optimizer will not recognize an index on an innodb table. tranfer_logs is an
innodb
table, auth_user is not. As demonstrated below, trans_team is not even recognized as
a possible
key when EXPLAIN SELECT is used. (my apologies for the extra wide message). I am not
sure if this
is an i
