数据库的查询优化

Database Query Optimization

数据库系统是管理信息系统的核心,基于数据库的联机事务处理(OLTP)以及联机分析处理(OLAP)是银行、企业、商业、政府等部门最为重要的计算机应用之一.而用户提交的SQL语句是系统优化的基础,如何设计高效合理的查询语句非常重要.根据多年的数据库应用程序开发实际经验,就查询优化问题,谈点实践体会.

Database system is the key of the management information system,Based on the database of online transaction processing(OLTP) and online analytical processing(OLAP) are the important computer application of banks,enterprises,business,and government departments.While the SQL statement Submitted by the users is the basis for system optimization.How to design effective and reasonable query is very important.This paper supposes some query optimization experiences based on years of database application development.