CodePudding user response:
Database optimization method, sums up the application layer of the optimization (SQL optimization) and the optimization of the system level, and the optimization of the most common application layer surface, the effect is most obvious, the contents of the SQL optimization involves many aspects, it has a complete theoretical system, the need to enrich the experience, because a lot of content, cannot give details here, interested can look at my SQL tuning book, of course, you can not buy, there are sample chapter, according to the directory you can understand the SQL tuning method and content, and then, through the network or other way to understand when it comes to content,Sample chapter addresses I also stick to you: http://blog.csdn.net/tuning_optmization/article/details/77868635
CodePudding user response:
System level optimization, need solid basis of knowledge to the theory of database system, need more rich experience and deep understanding, but in reality than the application layer of the optimized scenario less, often less significant effect,CodePudding user response:
About SQL optimization problem, the first to see which database is used, if the oracle, need to pay attention to it if you can use exist don't use in the SQL statement in capital and so on as far as possible, of course, these are the theoretical level, eventually to combine specific questions