1
SET SESSION storage_engine=pbxt;
2
create table t1 (a int primary key);
3
insert into t1 values (1),(2),(3);
4
explain select * from t1 order by a desc;
5
id select_type table type possible_keys key key_len ref rows Extra
6
1 SIMPLE t1 index NULL PRIMARY 4 NULL 3 Using index; Using filesort
7
select * from t1 order by a desc;