Unnamed

mysql> show index from hp1d;
+-------+------------+-------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name          | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+-------+------------+-------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| hp1d  |          0 | PRIMARY           |            1 | sym         | A         |        NULL |     NULL | NULL   |      | BTREE      |         |
| hp1d  |          0 | PRIMARY           |            2 | pdatetime   | A         |    15378685 |     NULL | NULL   |      | BTREE      |         |
| hp1d  |          1 | hp1d_sym_date_idx |            1 | pdatetime   | A         |       11200 |     NULL | NULL   |      | BTREE      |         |
| hp1d  |          1 | hp1d_sym_date_idx |            2 | sym         | A         |    15378685 |     NULL | NULL   |      | BTREE      |         |
+-------+------------+-------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+