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?

Question

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?

Accepted Answer

C. Look for Hash Match operators in the execution plan.

Answer

A. Look for table scans in the execution plan.

Answer

B. Look for Merge Join operators in the execution plan.

Answer

D. Look for Nested Loops operators in the execution plan.

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…

Question

Options

How the community answered

Community Discussion