sql性能优化（SQL performance tuning）.docVIP

sql性能优化（SQL performance tuning） About the performance optimization of SQL, Where exactly does it start? According to my current SQL article One Select count (*) changed to select count (field 1) Two Select, tableA.*, and so on, change to select tableA. field 1, field 2 Three From tableB tableC, the local Cartesian product, according to the relationship between the tables, into inner join Id like to ask, specifically, where there is a need to pay attention. Select from TableA Left join tableB on Left join tableC on I want to ask, I dont want all of the fields in tableB for the desired results, Select from TableA Left join (select required field from tableB) tableB on This kind of writing, that performance is better. The range is too wide. Ive written one thing before. Its for the companys new peoples education and training. I dont know if it will help you. I know the writing is not so good. (I didnt come out.) you must not scold me!!! Just give the landlord some information SELECT statement optimization design 1. overview of the importance of database query optimization Optimization overview In fact, we find that many people just need to retrieve information from a database. These people are more numerous than those who work with database programming and applications. Moreover, the efficiency of data query has a direct impact on the efficiency of software and enterprise operations. The SQL statement is in the process of developing stage have decided the SQL statement because of low efficiency brought to database performance problems, often in operation for a period of time after the database came out, but found that after the change to change, can not become a performance bottleneck breakthrough. Because almost all databases inevitably run some inefficient SQL statements. Tuning of database performance is often initiated from the optimization of SQL statements. The optimization of the SQL statement can reduce the load and improve the efficiency of the database. Compa