摘要
随之数据库的广泛使用,数据库的性能日益受到人们的关注。然而,因数据库的系统结构复杂,它的性能受到多方面的影响,其中查询操作是影响其性能的重要因素。为提高数据库的查询效率,达到数据库的性能优化目的。该文提出了数据库查询优化的一些策略,其中包含了使用合理的索引、查询语句优化、合理使用临时表、窗口优化以及利用优化器实现查询优化等。
With the wide use of database,its performance is drawing more and more attention from people.However,due to the complex systematic structure of database,its performance is influenced by various aspects,among which query operation is a key factor.To improve the query efficiency of database and achieve the purpose of optimization of its performance,the paper proposes some strategies to optimize database query,including use of proper index,optimization of query statement,proper use of temporary sheet,optimization of windows and realization of query optimization using optimizer etc.
出处
《电脑知识与技术(过刊)》
2011年第2X期977-978,980,共3页
Computer Knowledge and Technology
关键词
数据库
查询优化
索引
语句优化
database
query optimization
index
statement optimization