HOTSPOT
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. (Click the Exhibit button.)
Plan 10 is shown in the Plan 10 Execution Plan exhibit. (Click the Exhibit button.)
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. (Click the Exhibit button.)
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.
Plan 2 Execution Plan
Plan 10 Execution Plan
Tracked Queries
Hot Area:
No
Yes
Yes