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

[Toxic Head]

This is possibly better readable ;-)

[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]

GreetZ'n ThanX Toxic



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