SQL Server - Optimize stored procedure with many inner joins

Asked By anbu n on 27-Aug-13 05:23 PM
Got a stored procedure, first with continuous 5 inner joins and next 4 left joins. how to optimize this procedure , can i use temp tables instead of continuous inner join , will their be any improvement
Robbe Morris replied to anbu n on 27-Aug-13 05:24 PM
Gee, I don't know.  Perhaps posting your query would be helpful?  Have you run "Display Estimated Execution Plan" when running the stored procedure in Query Analyzer to see if SQL Server suggests any indexes?