Hi, I have an SQL query which is doing a select joining several tables based on certain conditions. There are 35 joins and 35 conditions. We are using SQL Server 2005. The problem is that this particular query is taking unusally long time (17 hrs) to execute in the production server whereas the same query used to take only 10 minutes to execute in previously since years. We are exploring whether what could have gone wrong all of a sudden. What could be the probable reasons and what should I investigate. Any suggestion is highly appreciated. Thanks in advance. Sagar.