Query Rewriting Research and Application in Query Optimization
Yaxin Liu · Journal of Dalian Jiaotong University · 2009
Query optimization is an important technique for designing and implementation database system and a crucial factor that affects the capability of the database.Aim at the factual problem of query efficiency,the concretely executive process of SQL statement reference to the characteristic of database query is analyzed.Based on Dalian Criminal Interrogation assistance decision support system,materialized view is constructed,and the SQL statement is rewritten,which improves query efficiency.