基于合理索引的数据库查询优化研究

Application Research of Efficient Index and Database Query Optimization

随着数据库技术的广泛应用,数据库中存储的数据日积月累不断的增加,数据库查询的效率不可避免的降低,如何提高数据库的查询效率成为每个数据库管理员必须研究的问题。首先介绍了数据库索引的概念和作用,解析了两种不同索引结构的区别,再通过实例分析,介绍如何建立合理的数据库索引来优化数据库查询。

With the extensive application of database technology,the increasing amount of database and declining efficiency of database query,how to improve the efficiency of a database query has become a point to database administrator.This paper introduces the concept and role of database indexes,parses the differences between two different index structures,and exemplifies how to establish a rational database indexes to optimize database queries.