August 2002
Intermediate to advanced
528 pages
10h 12m
English
The purpose of this chapter is to offer some simple techniques that will help make your SQL more efficient and effective. A few weeks after I had taken my first SQL course, I could write statements that produced the results I desired. As the complexity of my queries increased, I began to notice that I was spending a lot of time watching the hourglass cursor blink. I was very happy knowing that I knew how to make the computer work hard. This went on until a colleague took one of my statements, changed parts of the statement, and got it to execute three times faster. I learned then that mastering the SQL language was half the battle. The other part of the battle was to get the SQL to perform ...