优化SQL查询的15个方式（转载）

'value'

Hence, run faster.

Summary

Definitely, these optimization tips doesn’t guarantee that your queries won’t become your system bottleneck. It will require much more benchmarking and profiling to further optimize your SQL queries. However, the above simple optimization can be utilize by anyone that might just help save some?colleague?rich bowl while you learn to write good queries. (its either you or your team leader/manager)

http://hungred.com/useful-information/ways-optimize-sql-queries/