357
357
explain select * from t1 where a = 1 order by b desc;
358
358
id select_type table type possible_keys key key_len ref rows Extra
359
359
1 SIMPLE t1 ref a a 4 const 5 Using where; Using index
360
explain select * from t1 where a = 2 and b > 0 order by a desc,b desc,b,a;
363
explain select * from t1 where a = 2 and b < 2 order by a desc,a,b desc,a,b;
360
366
select * from t1 where a = 1 order by b desc;