You work in an International company named TAKEEEN. And you’re in charge of the database of your company. You intend to use SQL Server 2008 to create a database solution.
A database will contain 10 tables that are used to generate reports. The range of the data in the tables varies from 50,000 to 100,000 records.
During a query execution that joins four tables, you discover the following problems:
• It takes a quite long time for the query to execute.
• The size of the tempdb database grows considerably.
Now you have to analyze the execution plan to identify the most likely cause for the problems.
So what should you do?
A. Look for Hash Match operators In the execution plan.
B. Look for Nested Loops operators In the execution plan.
C. Look for table scans in the execution plan.
D. Look for Merge Join operators in the execution plan.
