GitHub user avamingli added a comment to the discussion: Are there any plans to further develop GPORCA to support all query performance optimizations?
> However, this legacy optimizer produces extremely complex and generally poor > plans for large queries compared to GPORCA. Max and I previously discussed a related topic and plan to enhance our AQUMV feature to support complex SQL queries. Specifically, we aim to ensure that all examples from TPC-DS can utilize the AQUMV functionality. This will greatly address the efficiency issues related to complex queries, especially in cases like those in TPC-DS. Additionally, we intend to support two different optimizers so that users can quickly obtain query results regardless of which one they choose to use. This is a complex and long-term task, and it is already on my list of plans. GitHub link: https://github.com/apache/cloudberry/discussions/729#discussioncomment-11379885 ---- This is an automatically sent email for dev@cloudberry.apache.org. To unsubscribe, please send an email to: dev-unsubscr...@cloudberry.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@cloudberry.apache.org For additional commands, e-mail: dev-h...@cloudberry.apache.org