Sams Teach Yourself SQL

Chapter 17. Improving Database Performance

During this hour, you learn how to tune your SQL statement for maximum performance using some very simple methods.

The highlights of this hour include:

• What SQL statement tuning is

• Database tuning versus SQL statement tuning

• Formatting your SQL statement

• Properly joining tables

• The most restrictive condition

• Full table scans

• Invoking the use of indexes

• Avoiding the use of OR and HAVING

• Avoiding large sort operations

What Is SQL Statement Tuning?

SQL statement tuning is the process of optimally building SQL statements to achieve results in the most effective and efficient manner. SQL tuning begins with the basic arrangement of the elements in a query. Simple formatting can play a rather large role in the optimization ...