(Mark Callaghan) The explain command in MySQL is very useful. Alas, it has its limits including some related to the use of the LIMIT clause. This is even more reason to do more than EXPLAIN when testing a query.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help