浅谈数据库优化查询技术

Introduction of Database Optimizing Query Technology

大型关系数据库的优化通常可以通过对网络、硬件、操作系统、数据库参数和应用程序的优化来进行。根据统计 ,对网络、硬件、操作系统、数据库参数进行优化所获得的性能提升 ,全部加起来只占数据库系统性能提升的 40 %左右 ,其余的 60 %系统性能提升来自对应用程序的优化 ,尤其是SQL语句的优化。本文重点从索引优化、存储过程以及对同一表进行多个选择运算的优化、多个表的联结兼选择运算的优化进行了阐述。

We can optimize large-scaled relational database by optimizing network、hardware、operating system、database parameter and application program.According to the statistics,the functions improved by optimizing network、hardware、operating system、database parameter add up to only 40% in opimizing the functions of the whole database,the other 60% is attributed by optimizing the application program,especially optimizing the SQL language.In this paper the author proposes an optimized design-optimizing index,using stored procedure,optimizing multi-choice operation on the same table,optimizing connection & choice operation on multi-tables.