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
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 ...