Can Mysql Cluster AQL(Push-Down Join) be trigger with sharding table at the same time?
Pushdown basically means that some part of the job is "pushed down" to data nodes. So performance gain is because:


data nodes can filter and process data in much more efficient way than SQL nodes. They "know" more about the physical details of the data
we save on SQL node - data node traffic. And latency between those two nodes is relatively high because of the MySQL Cluster design


Inter-data-node latency is much much lower. So data shipping does not have such impact on performance. And all the tables (except some absolute corner cases) are sharded between data nodes. For any data fetch data nodes must find which node holds active part of the required row.

This latency still cannot be ignored. One can find that for the best possible performance Dolphin Interconnect is suggested. But:


inter-data-node latency is lower
for one data fetch to SQL nodes several communication packets must pass between data nodes. And when filtering is done by data nodes much less packets are needed between data nodes for one processed row.