An execution plan or explain plan is an executable representation of an SQL statement. It is generated by the Optimizer and determines the sequence of database operations to execute an statement.
Appendix A: Getting and Reading Execution Plans
Article: „Planning for Re-Use“ about execution plan caching
Table of Contents
Training and Coaching
Expert, competent, or just a greenhorn? Test your SQL performance skills in just three minutes. ›
by Markus Winand.
Visit our sister site!
A lot has changed since SQL-92