Database inquiry optimization is a key factor to achieve good execution performance and simplify management.SQL inquiry is an ordered inquiry.The use of different statements and sequential order will directly affect the inquiry speed,which has a direct impact on the promotion and application of the database.The article focuses on two aspects of the study,the approach and statements made in optimization,which puts forward the methods of optimization and statements to achieve.%数据库查询优化是取得良好执行性能并简化管理的关键因素,SQL查询是一个有序的查询,不同语句的使用和使用顺序将直接影响其查询速度。查询速度的快慢直接影响着数据库的推广与应用,本文就优化思路及语句书写优化两方面进行讨论,提出优化方法及语句实现。
展开▼