Requirements:

Indexes $-$ Part A:

For each of the following scenarios, please display the execution plan and capture the image of the plan.

Save each image with a suitable name for submission.

SELECT the CustomerID, ContactName and CompanyName from the Customers table.

SELECT the CustomerID, OrderID, CompanyName and OrderDate from the Customers and

Orders tables.

SELECT the CustomerID, OrderID, CompanyName and OrderDate from the Customers and

Orders tables for all customers in Germany, and sort by the customer's company name.

Indexes $-$ Part B:

Create the following Indexes. Please keep all scripts in one script file for submission.

PRIMARY index for CustomerID in Customers $($You can do this by creating a Primary Key for

CustomerID in Customers$)$

PRIMARY Index for OrderID in Orders

Index for the CustomerID in the Orders table.

Index for Country in the Customers table.

Index for CompanyName in the Customers table.

Indexes $-$ Part C:

Repeat part A: and notice the changes based on the new indexes. Please capture the images of

the plans for each, and save it with a suitable name.