add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE my_table null ref index2,index1 index2 82 const,const 1 100.00 Using index condition
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE my_table null ref index2,index1 index2 41 const 1 100.00 Using index condition; Using filesort
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE my_table null ref index2 index2 82 const,const 1 100.00 Using index condition
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE my_table null ref index2 index2 41 const 1 100.00 Using index condition; Using filesort
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE my_table null ref index2 index2 82 const,const 1 100.00 Using where; Using index
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE my_table null ref index2 index2 41 const 1 100.00 Using where; Using index; Using filesort
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE my_table null ref index2,index1 index2 82 const,const 1 100.00 Using where; Using index
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE my_table null ref index2,index1 index2 41 const 1 100.00 Using where; Using index; Using filesort