MySQL Forums
Forum List  »  Optimizer & Parser

Re: Explain the order of query
Posted by: jongse park
Date: March 21, 2012 07:06PM

This is the result of Explain select ...

ID select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY T1 ref_or_null index_001,index005 index005 343 const 8122 Using where
1 PRIMARY T2 ref PRIMARY PRIMARY 59 T1.ord_id 1 Using where
4 DEPENDENT SUBQUERY ST ref ord_003 ord_003 100 const 5052308 Using where
2 DEPENDENT SUBQUERY S1 unique_subquery PRIMARY,index_006 PRIMARY 47 func 1 Using where
3 DEPENDENT SUBQUERY S1 const PRIMARY,index_005,index_006 PRIMARY 47 const 1

MySQL access order is : 1->1->4->2->3 OR 1->1->2->3->4 ?
Which one is right order?

Options: ReplyQuote


Subject
Views
Written By
Posted
1957
March 19, 2012 01:49AM
1024
March 19, 2012 10:38PM
Re: Explain the order of query
1030
March 21, 2012 07:06PM
825
March 22, 2012 06:01PM
863
March 22, 2012 08:13PM
860
March 23, 2012 07:57PM
1319
March 28, 2012 05:06AM


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.