Hi Recently, I've been conducting research on how to maximize the potential of Spool for CTE reuse optimization. My goal is to streamline the push down process and filters across all consumer nodes. However, I have encountered a roadblock as the current rule pattern fails to accurately describe the structure of Spool and its parent components. So, in the rule match we can not see the structure as a whole. Would greatly appreciate any guidance or insights on this topic.
Thanks, Aitozi