Chapter 12. What You Can Do If Your SQL Does Not Perform
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 ...
Get Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
