Im have a problem / misunderstanding with the 4.1 release. Im having issues
with indexes related to 'IN' vs '=' in subselects.
assume the subselect returns 1 value
select SQL_NO_CACHE user_id from table_a where user_id in (select
SQL_NO_CACHE user_id from table_b where ... blah)
9.5 seconds...
On Mon, Jun 09, 2003 at 12:46:32PM -0500, Christopher Knight wrote:
Im have a problem / misunderstanding with the 4.1 release. Im having issues
with indexes related to 'IN' vs '=' in subselects.
assume the subselect returns 1 value
select SQL_NO_CACHE user_id from table_a where user_id in