An execution plan is basically a road map that graphically or textually shows the data retrieval methods chosen by the SQL server’s query optimizer