Research and exploration of database querying optimization method
Junfeng Wang · Electronic Design Engineering · 2012
SQL is a programming language designed for accessing and manipulating databases.Although SQL is an ANSI standard,there are many different versions of the SQL language.Performance differs between versions due to different implementation methods,and the difference between large or complex database management systems is particularly obvious.Bad SQLs are often due to inappropriate index designs,inadequate join conditions and where clauses that can not be optimized.In this paper,Specific optimization strategies are proposed with SQL query optimization methods research.