I've added a new index to account for some performance issues however the queries that I would expect to be using the new index are still are not using it. In SQL Server you can flush an execution plan a couple of different ways to correct a poor performing query and I'm looking to understand if that is also possible in MySQL.
- Can a specific execution plan be removed?
- Can a all of the stored execution plans be removed?
EXPLAIN
, plusSHOW CREATE TABLE
.