I am curious to know the options to improve the performance of MySQL queries, does the storage plugin pushes down the queries to RDBMS
While exploring drill, i was testing out few scenarios and was impressed with the functionality to be able to join any data.
In one of my test i have executed an aggregate query via Drill (Storage plugin to mysql) and on Mysql DB, the fetch time is 5X more via storage plugin in Drill.
wanted to know how can the query execution time be reduced and which factors influence it.
Any help would be great.