Query Rewriting Relational Database Query Optimization Technology
Qi-Cai Chen · Computer Programming Skills & Maintenance · 2009
With the data warehouse technology more and more extensive,data warehouse query is also getting higher and higher frequency of use,based on the query rewriting relational database query optimization technology,through the view rewritten subquery merging predicate equivalent replacement,the use of temporary tables,as well as a set to replace UNION operator OR logic operations such as the use of technology,this article discussed in detail the database query optimizer query rewrite module design and implementation of XML,SQL statements,such as query rewriting method.