Image

7

The SQL Lifecycle

The lifecycle of optimizing SQL statements involves six distinct steps. These include the essential prerequisite steps of how you capture SQL statements, how you identify problem SQL statements, and how you confirm your SQL statement before you begin analysis.

In this chapter we discuss the following six steps of the full SQL optimization lifecycle:

• Capture SQL statements

• Identify and categorize problematic SQL statements

• Confirm current operation of SQL statements

• Analyze your SQL statement and supporting information

• Optimize your SQL statement

• Verify the results of SQL optimization

Capture Statements

Before ...

Get Effective MySQL Optimizing SQL Statements now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.