| 基于优化器的提高海量数据查询效率方法研究 |
| |
| 引用本文： | 谭磊,顾国强,王占宏.基于优化器的提高海量数据查询效率方法研究[J].计算机应用与软件,2012(1):207-210. |
| |
| 作者姓名： | 谭磊 顾国强 王占宏 |
| |
| 作者单位： | 上海市计算技术研究所;上海众恒信息产业股份有限公司;华东师范大学资源与环境学院 |
| |
| 摘 要： | SQL语句的质量是影响海量数据查询效率的关键因素。关于SQL查询优化的方法众多,涉及面较广。以上海市实有人口信息管理系统性能优化为实践基础,在描述SQL提示及其使用原则的同时,着重介绍SQL提示在提高海量数据查询效率方面的一些使用方法。
|
| 关 键 词： | 海量数据 查询提示 SQL优化器 索引 |
TO IMPROVE THE EFFICIENCY OF MASSIVE DATA QUERY METHOD BASED ON OPTIMIZER |
| |
| Tan Lei,Gu Guoqiang,Wang Zhanhong.TO IMPROVE THE EFFICIENCY OF MASSIVE DATA QUERY METHOD BASED ON OPTIMIZER[J].Computer Applications and Software,2012(1):207-210. |
| |
| Authors: | Tan Lei Gu Guoqiang Wang Zhanhong |
| |
| Affiliation: | 1(Shanghai Institute of Computing Technology,Shanghai 200040,China) 2(Shanghai Triman Information and Technology Co.,Ltd,Shanghai 200042,China) 3(School of Resources and Environment,East China Normal University,Shanghai 200062,China) |
| |
| Abstract: | 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. |
| |
| Keywords: | Massive data Query hint SQL optimizer Index |
| 本文献已被 CNKI 等数据库收录！ |
|
