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.