DRAG DROP
You use a Microsoft SQL Server 2012 database.
You need to create an indexed view within the database for a report that displays Customer Name and the total revenue for that customer.
Which four T-SQL statements should you use? (To answer, move the appropriate SQL statements from the list of statements to the answer area and arrange them in the correct order.)
Select and Place:
I agree SOLO.
I have seen this question b4 and the answer included GROUP BY.
Why would you create a UNIQUE CLUSTERED INDEX as well as a UNIQUE INDEX on CustomerID.
question: shouldn’t we have to use/add ?
GROUP BY O.CustomerID, C.CustomerName
GO
CREATE UNIQUE CLUSTERED INDEX
idx_vwCustomerRevenue
ON Sales.CustomerRevenue(CustomerID);