You are a database developer. You plan to design a database solution by using SQL Server
2008. A database will contain 10 tables that are used to generate reports. Data in the tables
ranges from 50,000 to 100,000 records. During a query execution that joins four tables, you
discover the following problems: ·The size of the tempdb database grows considerably.
·The query execution time is excessive. You need to identify the most likely cause for the
problems by analyzing the execution plan. What should you do?
A.
Look for table scans in the execution plan.
B.
Look for Merge Join operators in the execution plan.
C.
Look for Hash Match operators in the execution plan.
D.
Look for Nested Loops operators in the execution plan.