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