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

[Toxic Head]

I don't know what you mean with

 tags, but i can copy and paste the export result of 'explain' here:

id
select_type
table
type
possible_keys
key
key_len
ref
rows
Extra

+++

1
PRIMARY
item_t0
range
PRIMARY,Products_TypePKIndex,Products_visibilityIDX
PRIMARY
92

157
Using where

+++

2
DEPENDENT SUBQUERY
item_t2
ref
Cat2ProdRel_LinkTarget,Cat2ProdRel_TypePKIndex,Cat2ProdRel_LinkSource
Cat2ProdRel_LinkTarget
92
catalog.item_t0.PK
2
Using where

+++

2
DEPENDENT 
SUBQUERY
item_t1
ref
PRIMARY,Categories_TypePKIndex,Categories_versionIDX
Categories_versionIDX
93
const
19970
Using where

Created: 24.01.2007 13:10:10

I hope that helps...

GreetZ ToX