Meaning of “Select tables optimized away” in MySQL Explain plan

From the MySQL documentation:

The query contained only aggregate functions (MIN(), MAX()) that were
all resolved using an index, or COUNT(*) for MyISAM, and no GROUP BY
clause. The optimizer determined that only one row should be returned.

Basically this means your query uses data that is directly available to MySQL and the query will run in constant time.

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)