You are maintaining a Microsoft SQL Server database. You run the following query:

You observe performance issues when you run the query. You capture the following query execution plan:

You need to ensure that the query performs returns the results as quickly as possible.

Which action should you perform?

A. Add anew index to the ID column of the Person table.

B. Add a new index to the EndDate column of the History table.

C. Create a materialized view that is based on joining data from the ActiveEmployee and History tables.

D. Create a computed column that concatenates the Give nName and SurName columns.

Explanation:

Cost is 53% for the Table Scan on the Person (p) table. This table scan is on the ID column, so we should put an index on it.