hi , i’m using sqlserver2005.i have a stored procedure with 40 subqueries and 20 joins. How can i improve the execution time of that procedure.