摘要
查询优化是提高数据库性能的关键技术之一.在分析SQL Server关系数据库系统自动查询优化技术的基础上,介绍了索引的类型和使用原则,并结合实例讨论了SQL语句中使用索引进行查询优化的多种有效方法,有助于提高数据库的查询效率.
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.
出处
《洛阳大学学报》
2007年第2期83-86,共4页
Journal of Luoyang University
关键词
索引
关系数据库
查询优化
index
relational database
query optimization