摘要
数据库性能问题一直是决策者及技术人员共同关注的焦点,影响数据库性能的一个重要因素就是SQL查询语句的低效率。为了提高数据库应用系统的执行效率,在此从分析关系数据库查询处理过程入手讨论查询优化技巧,指出关系数据库查询优化的一般原则。通过几种优化策略的研究,在时间和空间上提高了系统的性能,在一定程度上提高了查询效率。
Database performance issue has been the decision- makers and technical staff of the focus of common concern, affecting database performance is an important factor in the low - SQL query efficiency. In order to improve the implementation of database application system efficiency,from analysis of the process of query processing relational database query optimization techniques to start the discussion,pointing out that the relational database query optimization as a general principle. Optimization strategy in several studies,in time and space to improve the performance of the system, to a certain extent to improve efficiency of the query.
出处
《现代电子技术》
2010年第4期152-153,156,共3页
Modern Electronics Technique
关键词
SQL
优化策略
数据库性能
谓词
SQL
optimization strategy
database performance
predicate