O'Reilly logo

Sams Teach Yourself SQL by Arie D. Jones, Ron Plew, Ryan Stephens

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required