explain someSql; possible_keys show useable keysexplain select a from b use index (c) where xxx ;show index from tableA;create index someIndex on someTable(someColumn);drop index someIndex on someTable;*************************** 1. row *************************** id: 1 select_type: SIMPLE table: some table partitions: NULL type: ALLpossible_keys: PRIMARY ...