Writing SQL Stored Procedures and Views with multiple Table joins is a very common task and have to ensure that the execution time should be minimal.
There are many possible SQL performance tuning tricks like usng indexer etc..
A very common one I am highlighting here i.e. performance of the SQL Query while using JOIN.
Scenario: You are using joins among multiple tables more than two.
Trick: Try to use the join in such an order that the table which contains the least number of records should come first and then subsequently put the tables with larger records.
INNER JOIN Table2 ON ..
INNER JOIN Table3 ON..
INNER JOIN Table4 ON..
Here execution time will be optimum if no. of records in the table are in order TABLE 4> 3> 2> 1, Here also the condition on which we are putting the joins could be a deciding factor.