SQL优化技术及应用

SQL Optimizing Technology and Application

随着信息化进程的加快,管理工作的逐步细化,SQL的优化直接影响着系统的运行状态和速度。根据软件设计开发过程中数据库设计和程序开发的技术和经验,通过实例总结了数据库访问SQL优化的方法和技巧,及在项目中的应用。通过优化,提高了系统运行速度,减少了系统故障,用户反馈良好。

With informatization progress acceleration and management gradual specifying, SQL optimization directly affects the running state and speed of the system. Basing on the technology and experience of database design and program development, the author summarizes the method and techniques of database access SQL optimization and describes its application in projects by example. After optimization, the system ran with higher speed and less failure and received good response from the customer.