Re: Indexes are not working after restoring dump

[Amit K]

Output of Query expalin

+----+--------------------+---------+--------+----------------+---------+---------+-------+---------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+--------------------+---------+--------+----------------+---------+---------+-------+---------+-------------+
| 1 | PRIMARY | t1 | ALL | NULL | NULL | NULL | NULL | 3492695 | Using where |
| 2 | DEPENDENT SUBQUERY | t3 | const | PRIMARY | PRIMARY | 4 | const | 1 | Using index |
| 2 | DEPENDENT SUBQUERY | t2 | eq_ref | PRIMARY,c2 | PRIMARY | 4 | func | 1 | Using where |
+----+--------------------+---------+--------+----------------+---------+---------+-------+---------+-------------+