Execution plans are the best window into understanding the choices made by the query optimizer as it attempts to make your query run quickly. Execution plans accurately describe the behaviors of your query, from the types of join operations to the indexes being used, as well as how they are used. Execution plans are absolutely not a measure of performance. That much must be made clear.