Hi,
As Amazon Athena is a [JDBC data source](https://community.denodo.com/docs/html/browse/latest/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources) and also it has its own [database adapter](https://community.denodo.com/docs/html/browse/latest/vdp/administration/appendix/supported_jdbc_data_sources/supported_jdbc_data_sources#jdbc-adapters-included-in-the-denodo-platform), then the Execution Engine will perform optimizations based on the **scenario** and **types** of queries.
However, the Execution Engine will optimize the queries only if the optimization is enabled in the Server Configuration of Virtual DataPort. Hence, I would make sure that I have enabled Queries optimization in the Server Configuration.
You could refer to the [Queries Optimization](https://community.denodo.com/docs/html/browse/latest/vdp/administration/server_administration_-_configuring_the_server/queries_optimization/queries_optimization) section under the Virtual DataPort Administration Guide for more details.
Also, I suggest you to refer the Knowledge Base (KB) article [Best Practices to Maximize Performance II: Configuring the Query Optimizer](https://community.denodo.com/kb/view/document/Best%20Practices%20to%20Maximize%20Performance%20II%3A%20Configuring%20the%20Query%20Optimizer?category=Best+Practices) which explains more about the Query Optimizer.
Hope this helps!
