摘要
数据库管理系统中,随着数据量的增加,数据查询的速度会越来越慢。因此如何设计高效合理的查询语句就显得非常重要。以应用实例为基础,结合数据库理论,介绍如何利用执行计划优化SQL查询,以提高系统的性能。
With the increase in the amount of data of Database management system, the speed of data query will become more and more slow. So it is very important to design efficient and reasonable query method. Based on the application examples and database theory, this paper introduces how to optimize SQL query by using execution plan to improve system performance.
出处
《电脑与电信》
2010年第6期81-83,共3页
Computer & Telecommunication
关键词
数据库
执行计划
优化
SQL查询
database
implementation plan
optimization
SQL query
