Database Admin You are executing the following query script into your database SELECT * FROM [WideWorldImporters].[Purchasing].[PurchaseOrders] WHERE ExpectedDeliveryDate >'2013-01-12' AND ExpectedDeliveryDate < '2013-01-25' AND OrderDate = '2013-01-04' ORDER BY ExpectedDeliveryDate DESC a. Please explain the query above based on Query/Execution Plan! Then execute this query: CREATE NONCLUSTERED INDEX IX_Test_ExpectedDeliveryDate ON[WideWorldImporters].[Purchasing].[PurchaseOrders](ExpectedDeliver yDate, OrderDate) b. Please explain again query 1 above after applying query 2 using Query/Execution Plan! What is the difference between after and before applying query 2. For database WideWorldImporters you can download it at https://github.com/Microsoft/sqlserver-samples/releases/download/wide-world-importers-v1.0/WideWorldImporters-Full.bak(.bak format). For bak format you can restore the database and for mdx format you can attach the database using SQL Server Management Studio.
You are executing the following query script into your database
SELECT *
FROM [WideWorldImporters].[Purchasing].[PurchaseOrders]
WHERE ExpectedDeliveryDate >'2013-01-12' AND ExpectedDeliveryDate < '2013-01-25' AND OrderDate = '2013-01-04'
ORDER BY ExpectedDeliveryDate DESC
a. Please explain the query above based on Query/Execution Plan!
Then execute this query:
CREATE NONCLUSTERED INDEX IX_Test_ExpectedDeliveryDate
ON[WideWorldImporters].[Purchasing].[PurchaseOrders](ExpectedDeliver yDate, OrderDate)
b. Please explain again query 1 above after applying query 2 using Query/Execution Plan! What is the difference between after and before applying query 2.
For database WideWorldImporters you can download it at https://github.com/Microsoft/sqlserver-samples/releases/download/wide-world-importers-v1.0/WideWorldImporters-Full.bak(.bak format). For bak format you can restore the database and for mdx format you can attach the database using SQL Server Management Studio.
Step by step
Solved in 2 steps
