O'Reilly logo

MySQL 5.0 Certification Study Guide by Carsten Pedersen, Stefan Hinz, Paul DuBois

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

22 Basic Optimizations

This chapter discusses general principles that are useful for optimizing queries to run more efficiently. It covers the following exam topics:

Image An overview of general optimization principles

Image Using indexing and other techniques to optimize query execution

Image Choosing storage engines to match application requirements

22.1 Overview of Optimization Principles

There are several optimization strategies that you can take advantage ...

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