Denodo engine provides a sophisticated query optimizer. To enable the static and/or dynamic query optimizations you can go to the server configuration and go to the queries optimization tab. You can choose to turn all the possible optimization. You can find some more details about the types of query optimization in the link below:
To check which query optimization has been applied to the query, you can go to the execution trace and click on the execution plan. You can refer to this document for more details
To know more on optimization and it’s best practices I would suggest you go through the links below
You can also take a test drive to learn more about optimization and have some hands-on using this link below
Hope this helps!