HOTSPOT
You have Microsoft SQL Server on a Microsoft Azure virtual machine. The virtual machine has a database named DB1. DB1 contains a table named Table1 that has 4 billion rows.
Users report that a query using Table1 takes longer than expected to execute.
You review the execution plan for the query and discover that the expected number of returned rows is one, while the actual number of returned rows is 1 million.
You need to reduce the amount of time it takes for the query to execute. The solution must prevent additional performance issues from being introduced.
Hot Area:
