SQL execution plans and Indexes

In order to appreciate the on what indexes are to offer, we need first to understand what are execution plans. Execution plan - To be able to execute queries, the SQL Server Database Engine must analyze the statement to determine an efficient way to ...