Question

英语翻译数据库系统是管理信息系统的核心,它涉及到系统的效率,影响整个系统的性能.随着数据库技术的发展,数据库的规模越来越

Answer 1

The database system is the core of management information system,it involves the efficiency of system,the influence the performance of the whole system.Along with the development of the database technology,the scale of the database is more and more big,the processing of the data operation is also more and more complicated.If a designer in the development of no account of the database optimized,the use of the database in the process,as the amount of data in the database increases,execute an access database SQL statements may take quite a long time,this reduces the speed of the application system,application system efficiency is very low,this makes the optimization of SQL query into an urgent need to address the problem.This paper first analyzes the influence of several reasons,SQL performance next preliminary analysis of the SQL optimization general steps,and then from three of the most important aspects to discuss how to do one optimization inquires the.