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

摘要

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