HOW TO ACCELERATE SQL′S EXECUTION
Lei Zhao · Journal of Suzhou Institute of Silk Textile Technology · 2000
As we all know, SQL Language is a standard database language. It provides datatase with rich operational command, especially in query area. However, people are often trapped into a wrong side when they use SQL, that is they pay more attention to the result and neglect that different aapproaches will leda to different qualities. This quality′s difference is very apparent in large or complicated database environment. Bad SQL often comes from improper index desigh, imsufficient join, and unable optimized ‘where’ sentence. After optimizing bad SQL, we can accelerate SQL′s execution.