MySQL DML - Querying Data

LESSON 4: Query Efficiency

Determine if your query is doing table scans. This lesson introduces you to how to evaluate your queries to determine how efficient they are. Are you using and index or primary key to access the data. What can you do, if anything, if you determine your query is not efficient.

MySQL Topics Covered

  • MySQL Query Efficiency
  • MySQL Explain Plans
  • Explain Extended
  • Viewing Table Schema