基于优化器的提高海量数据查询效率方法研究

TO IMPROVE THE EFFICIENCY OF MASSIVE DATA QUERY METHOD BASED ON OPTIMIZER

SQL语句的质量是影响海量数据查询效率的关键因素。关于SQL查询优化的方法众多,涉及面较广。以上海市实有人口信息管理系统性能优化为实践基础,在描述SQL提示及其使用原则的同时,着重介绍SQL提示在提高海量数据查询效率方面的一些使用方法。

SQL statement quality is a vital factor that influences the efficiency of massive data query.There are numerous ways to optimize SQL queries that cover a wide range.Based practically on Shanghai solid population information management system performance optimization,the paper on the one hand describes SQL hint and its application principles,on the other hand emphasizes on a few application methods of SQL hint upon improving the massive data query efficiency.