Question

A retail company runs an Azure SQL Database. Analysts complain that queries filtering customer orders by the CustomerEmail column are very slow because the database must scan the entire Orders table each time. A database administrator wants to create a database object that improves the retrieval speed of these lookups without changing the table's data. Which database object should the administrator create?

Accepted Answer

An index on the CustomerEmail column

Answer

A view that selects all rows from the Orders table

Answer

A stored procedure that returns all orders

Answer

A foreign key linking Orders to Customers