Optimizing SQL With Execution Plans

Posted on Wednesday, July 24, 2013 @ 00:08:32 PDT in MySQL
by Raven

Following a Plan

The execution plan (often called the query execution plan or the explain plan) contains the individual steps a database goes through to execute a SQL statement. For example, execution plans provide information on which indexes are used, in which order access to the various tables occurs, and what algorithms are used for joins, sorting, and grouping operations.

The execution plan roughly corresponds to bytecode in scripting languages like Perl or Python it is used internally to execute SQL statements. Creating an execution plan is sometimes also known as a compiling. However, this is more commonly referred to as the prepare phase ....

(More)
 
 
click Related        click Share
 
News ©

Site Info v2.2.2

Last SeenLast Seen
Server TrafficServer Traffic
  • Total: 339,305,383
  • Today: 12,713
Server InfoServer Info
  • Oct 23, 2017
  • 03:05 am PDT
 
 

Daily Inspiration