You are a database developer. You plan to design a database solution by using SQL Server 2008. Users report poor performance of a long-running query in a database. You fail to detect the cause of…

You are a database developer. You plan to design a database solution by using SQL Server 2008. Users report poor performance of a long-running query in a database. You fail to detect the cause of poor performance when you examine the estimated execution plan. On viewing the actual execution plan, you discover that several tasks are CPU-intensive. You need to ensure that you can view an estimated execution plan containing the most likely actions. You want to achieve this goal by incurring minimum possible CPU overhead. What should you do?