Hi luchen.xu
SubstitutionVisitor: based on pattern, and bottom-up visit.
MaterializedViewRule: analyze semantics with relnode, such as SPJA
I have focused on the way of SubstitutionVisitor, let me talk about the
advantages and disadvantages:
Advantages:
1. Expand easily: you can define a custom
I try to answer the first question. The materialized view rewriting of
`SubstitutionVisitor` is based on the equivalent replacement of relational
algebra expressions. Disadvantages of it are explained on the website [1].
1. it might need to enumerate exhaustively all possible equivalent
hello,
This problems keeps making me puzzled.
question1: what is the differences between the two implemenrations of
view-based query rewriting?Advantages and disadvantages
based on view substitution( SubstitutionVisitor、rules:unifyrule)
Rewriting using plan structural