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

[Toxic Head]

btw.: the "select" of course without "explain" :-)

And here are the index columns:
Categories ->

Key_name Column_name Cardinality Index_type
PRIMARY PK 80610 BTREE
Categories_TypePKIndex TypePkString 2 BTREE
Categories_versionIDX p_catalogversion 25 BTREE
Categories_codeIDX p_code 26870 BTREE
Categories_codeVersionIDX p_code 26870 BTREE
Categories_codeVersionIDX p_catalogversion 80610 BTREE
Categories_extID p_externalid 80610 BTREE


Products ->

Key_name Column_name Cardinality Index_type
PRIMARY PK 852628 BTREE
Products_Product_Code Code 852628 BTREE
Products_TypePKIndex TypePkString 4 BTREE
Products_baseIDX p_baseproduct 852628 BTREE
Products_catalogIDX p_catalog 10 BTREE
Products_versionIDX p_catalogversion 18 BTREE
Products_visibilityIDX p_approvalstatus 1 BTREE
Products_visibilityIDX p_onlinedate 852628 BTREE
Products_visibilityIDX p_offlinedate 852628 BTREE
Products_codeVersionIDX Code 852628 BTREE
Products_codeVersionIDX p_catalogversion 852628 BTREE


Cat2ProdRel ->

Key_name Column_name Cardinality Index_type
PRIMARY PK 1406452 BTREE
Cat2ProdRel_LinkTarget TargetPK 703226 BTREE
Cat2ProdRel_TypePKIndex TypePkString 1 BTREE
Cat2ProdRel_LinkSource SourcePK 50230 BTREE
Cat2ProdRel_Qualifier Qualifier 1 BTREE

***
I hope the information is enough. If you need some more, don"t hesitate to ask for :-)

GreetZ Toxic