MySQL Forums
Forum List  »  Optimizer & Parser

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

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: SQL Newbie needs urgently help! [optimizing query]
2296
January 24, 2007 06:18AM


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.