Re: Explain the order of query

[jongse park]

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?