| 基于索引的关系数据库查询优化 |
| |
| 引用本文： | 魏威,马国峰.基于索引的关系数据库查询优化[J].洛阳大学学报,2007,22(2):83-86. |
| |
| 作者姓名： | 魏威 马国峰 |
| |
| 作者单位： | 郑州铁路职业技术学院,河南,郑州,450052 |
| |
| 摘 要： | 查询优化是提高数据库性能的关键技术之一.在分析SQL Server关系数据库系统自动查询优化技术的基础上,介绍了索引的类型和使用原则,并结合实例讨论了SQL语句中使用索引进行查询优化的多种有效方法,有助于提高数据库的查询效率.
|
| 关 键 词： | 索引 关系数据库 查询优化 |
| 文章编号： | 1007-113X（2007）02-0083-04 |
| 修稿时间： | 2007-04-26 |
Query Optimization of Relational Database Based on Index |
| |
| WEI Wei,MA Guo-feng.Query Optimization of Relational Database Based on Index[J].Journal of Luoyang University,2007,22(2):83-86. |
| |
| Authors: | WEI Wei MA Guo-feng |
| |
| Institution: | Zhengzhou Railway Vocational and Technical College, Zhengzhou 450052, China |
| |
| Abstract: | Query optimization is a key technique for improving database performance.Based on the analysis of automatic query optimization of SQL Server relational database system,this paper introduces the category and use principles of index,and discusses many effective methods of query optimization based on index in SQL sentences via cases,which can promote the query efficiency of database. |
| |
| Keywords: | index relational database query optimization |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
