Hour 23

Improving Database Performance

What You’ll Learn in This Hour:

  • ▶   Defining SQL statement tuning

  • ▶   Comparing database tuning and SQL statement tuning

  • ▶   Properly joining tables

  • ▶   Understanding the problems of full table scans

  • ▶   Invoking the use of indexes

  • ▶   Avoiding the use of OR and HAVING

  • ▶   Avoiding large sort operations

In this hour, you learn how to tune your SQL statement for maximum performance using some simple methods. Although so far this book has focused on how to write SQL, it is just as important to learn how to write efficient SQL that can help keep the database running optimally. This hour focuses on simple steps you can take when working with various queries to ensure that your SQL performs optimally.

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

Start your free trial