Re: SQL Newbie needs urgently help! [optimizing query]

[Toxic Head]

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.