LESSON 16Streamlining SQL Statements for Improved Performance

Streamlining SQL statements is as much a part of application performance as database designing and tuning. No matter how fine-tuned the database or how sound the database structure, you will not receive timely query results that are acceptable to you, or even worse, acceptable to the customer, if you don’t follow some basic guidelines. Trust us, if the customer is not satisfied, you can bet your boss won’t be satisfied either.

You already know about the major components of the relational database language of SQL and how to communicate with the database; now it’s time to apply your knowledge to real-life performance concerns. The objective of today is to recommend methods for improving ...

Get Sams Teach Yourself SQL in One Hour a Day, Fifth Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.