top of page

Create Index Based on Query Plan

You use Query Store to optimize a query in a database. The query has two execution plans: ✑ Plan 2 is shown in the Plan 2 Execution Plan exhibit.

✑ Plan 10 is shown in the Plan 10 Execution Plan exhibit.

You create an index at 22:24 based on the missing index suggestion in Plan 2. The average duration statistics for the query is shown in the Tracked Queries exhibit.

You need to analyze the operators in the two execution plans.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

 

Answer Given:

 

Discussion:

Zikato

I see no clustered index scan there. Also the hash match operator didn't process morerows. By making the index seek more effective the percentage moved to other operator - number of rows is the same.

Bartek

Yes, in addition I think query throughpull II increase in plan 10. Just we can see it on Query Store diagram

Kuratko

NO (same or less -> smaller data & less data pages in NCI);

YES (Icons says "we are scans"; labels says: "we are seeks" -> seeks are *mostly* effec.)

YES ("same data" in shortest duration)


bottom of page