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