基于关系数据库的查询优化的方法研究

Research on query optimization methods based on relational database

通常如何提高运行速度及执行效率是检验关系数据库系统性能好坏的重要标志,需要进行优化设计的地方很多,大体上有逻辑设计、物理设计和查询几个阶段。而相对于其他操作,查询操作所占的比重很大,因此可以说查询速度决定了关系数据库的性能优劣。文章重点讨论查询优化的一些方法,并结合它在实际应用中的例子进行分析。

Generally,how to improve the operation speed and execution efficiency is an important symbol for testing the performance of the relational database system.There are many places which need to be optimized,including several stages such as logic design,physical design and query.Query operation constitutes the majority among them,so we can say the query speed determines the performance of the relational database.This paper focuses on the query optimization methods and analyzes them with the practical application examples.