mysql> ANALYZE TABLE tbl1 ; +----------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------+---------+----------+----------+ | testdb.tbl1 | analyze | status | OK | +----------------+---------+----------+----------+ 1 row in set (28.74 sec) mysql> ANALYZE TABLE tbl2 ; +-----------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------------+---------+----------+----------+ | testdb.tbl2 | analyze | status | OK | +-----------------+---------+----------+----------+ 1 row in set (11.57 sec) mysql> explain extended SELECT * FROM tbl1 WHERE COL01 > 'value from Query1' ORDER BY PAR_DATE DESC LIMIT 10; +----+-------------+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+-------+---------------+---------+---------+------+------+----------+-----------------------------+ | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra | +----+-------------+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+-------+---------------+---------+---------+------+------+----------+-----------------------------+ | 1 | SIMPLE | tbl1 | PF_201801,PF_201802,PF_201803,PF_201804,PF_201805,PF_201806,PF_201807,PF_201808,PF_201809,PF_201810,PF_201811,PF_201812,PF_201813,PF_201814,PF_201815,PF_201816 | range | PRIMARY | PRIMARY | 66 | NULL | 1 | 100.00 | Using where; Using filesort | +----+-------------+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+-------+---------------+---------+---------+------+------+----------+-----------------------------+ 1 row in set, 2 warnings (0.04 sec) mysql> SHOW WARNINGS ; +---------+------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Level | Code | Message | +---------+------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Warning | 1681 | 'EXTENDED' is deprecated and will be removed in a future release. | | Note | 1003 | /* select#1 */ select `testdb`.`tbl1`.`COL01` AS `COL01`,`testdb`.`tbl1`.`PAR_DATE` AS `PAR_DATE`,`testdb`.`tbl1`.`COL02` AS `COL02`,`testdb`.`tbl1`.`COL03` AS `COL03`,`testdb`.`tbl1`.`TMST` AS `TMST`,`testdb`.`tbl1`.`COL42` AS `COL42`,`testdb`.`tbl1`.`APLY_TMST` AS `APLY_TMST`,`testdb`.`tbl1`.`APLY_TMST2` AS `APLY_TMST2` from `testdb`.`tbl1` where (`testdb`.`tbl1`.`COL01` > 'value from Query1') order by `testdb`.`tbl1`.`PAR_DATE` desc limit 10 | +---------+------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 2 rows in set (0.00 sec) mysql> explain extended SELECT * FROM tbl2 WHERE COL01 > 'value from Query1' ORDER BY PAR_DATE DESC LIMIT 10; +----+-------------+--------+-------------------------------+-------+---------------+---------+---------+------+------+----------+-----------------------------+ | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra | +----+-------------+--------+-------------------------------+-------+---------------+---------+---------+------+------+----------+-----------------------------+ | 1 | SIMPLE | tbl2 | PF_201801,PF_201802,PF_201803 | range | PRIMARY | PRIMARY | 66 | NULL | 1 | 100.00 | Using where; Using filesort | +----+-------------+--------+-------------------------------+-------+---------------+---------+---------+------+------+----------+-----------------------------+ 1 row in set, 2 warnings (0.00 sec) mysql> SHOW WARNINGS ; +---------+------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Level | Code | Message | +---------+------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Warning | 1681 | 'EXTENDED' is deprecated and will be removed in a future release. | | Note | 1003 | /* select#1 */ select `testdb`.`tbl2`.`COL01` AS `COL01`,`testdb`.`tbl2`.`PAR_DATE` AS `PAR_DATE`,`testdb`.`tbl2`.`COL02` AS `COL02`,`testdb`.`tbl2`.`COL03` AS `COL03`,`testdb`.`tbl2`.`TMST` AS `TMST`,`testdb`.`tbl2`.`COL42` AS `COL42`,`testdb`.`tbl2`.`APLY_TMST` AS `APLY_TMST`,`testdb`.`tbl2`.`APLY_TMST2` AS `APLY_TMST2` from `testdb`.`tbl2` where (`testdb`.`tbl2`.`COL01` > 'value from Query1') order by `testdb`.`tbl2`.`PAR_DATE` desc limit 10 | +---------+------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 2 rows in set (0.00 sec)