MySQL Forums
Forum List  »  Optimizer & Parser

Re: SQL Newbie needs urgently help! [optimizing query]
Posted by: Toxic Head
Date: January 24, 2007 07:32AM

Okay here is it ;-)

id	select_type		table	type	possible_keys			key			key_len	ref			rows	Extra
1	PRIMARY			item_t0	range	PRIMARY,Products_TypePKIndex,	PRIMARY			92				157	Using where
						Products_visibilityIDX				
2	DEPENDENT SUBQUERY	item_t2	ref	Cat2ProdRel_LinkTarget,		Cat2ProdRel_LinkTarget	92	catalog.item_t0.PK	2	Using where
						Cat2ProdRel_TypePKIndex,
						Cat2ProdRel_LinkSource		
2	DEPENDENT SUBQUERY	item_t1	ref	PRIMARY,Categories_TypePKIndex,	Categories_versionIDX	93	const			19970	Using where
						Categories_versionIDX,
						Categories_catalogVersion



Edited 1 time(s). Last edit at 01/24/2007 07:33AM by Toxic Head.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: SQL Newbie needs urgently help! [optimizing query]
2360
January 24, 2007 07:32AM


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.