Hi Roxio, How are you doing today?

The difference in query times between materialized views and tables likely comes from the complexity of the views, as they often involve more steps in the background. To reduce the optimization time, you can try simplifying the materialized view, ensuring good data partitioning, and using techniques like Z-ordering or clustering. Also, make sure your caching is efficient and check the query execution plan for any bottlenecks. These steps should help speed things up!

Reagtds,

Brahma