MySQL Forums
Forum List  »  Newbie

Re: SQL query to return all matching condition
Posted by: Felix Geerinckx
Date: July 06, 2005 07:28AM

Faheem Hameed wrote:

> ----------------------------------------------------------------
> id select_type table type possible_keys key key_len ref rows Extra
> 1 PRIMARY a ALL Shelter_Code NULL NULL NULL 555 Using where; Using temporary
> 1 PRIMARY b ref serial_shelter serial_shelter 301 texon.a.Shelter_Code 5 Using where; Using index; Distinct
> 2 DEPENDENT SUBQUERY c range cat_sub_cat cat_sub_cat 181 NULL 382 Using where; Using filesort
> -------------------------------------------------- --------------

I'm afraid it is at present a limitation of the subquery optimizer. Your subquery is listed as DEPENDENT and in fact it isn't - see http://bugs.mysql.com/bug.php?id=10309

--
felix
Please use BBCode to format your messages in this forum.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.