Re: Partition Pruning based on subquery / join result

[Rick James]

Please use aliases on all fields in the SELECT; I cannot tell which fields are in ff vs dd.

I need to see the table definitions; please provide
* SHOW CREATE TABLE tbl\G -- engine, indexes
* SHOW TABLE STATUS LIKE 'tbl'\G -- sizes
* EXPLAIN SELECT ...\G -- clues of inefficiencies
* SHOW VARIABLES LIKE '%buffer%'; -- cache size
and surround them with [ code ] and [ / code ]