Skip navigation links

MySQL Forums :: General :: Sub Query is Very Slow


Advanced Search

Re: Sub Query is Very Slow
Posted by: Asad ahmed ()
Date: December 04, 2011 10:52PM

@Peter after runing your mentioned query i got following result: 


"id"	"select_type"	"table"	"type"	"possible_keys"	"key"	"key_len"	"ref"	"rows"	"filtered"	"Extra"
"1"	"SIMPLE"	"o"	"index"	\N	"articlenumber"	"28"	\N	"67483"	"100.00"	"Using index"
"1"	"SIMPLE"	"i"	"range"	"heading"	"heading"	"153"	\N	"66005"	"100.00"	"Using where; Using index"

Options: Reply•Quote


Subject Written By Posted
Sub Query is Very Slow Asad ahmed 12/02/2011 11:33PM
Re: Sub Query is Very Slow Peter Brawley 12/03/2011 01:38PM
Re: Sub Query is Very Slow Asad ahmed 12/04/2011 10:52PM
Re: Sub Query is Very Slow Peter Brawley 12/05/2011 02:30AM
Re: Sub Query is Very Slow Asad ahmed 12/05/2011 03:15AM
Re: Sub Query is Very Slow Rick James 12/05/2011 11:44PM
Re: Sub Query is Very Slow Rick James 12/05/2011 11:48PM
Re: Sub Query is Very Slow Asad ahmed 12/06/2011 02:13AM


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

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.