Hour 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
Get Sams Teach Yourself SQL in 24 Hours, Second Edition 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.