Use a clustered index on the column most used in JOIN statements, add non-clustered indexes on other columns commonly used in the WHERE clause, and use cross apply and table valued functions to simplify the time needed for the query engine to make a query execution plan on queries with many joins.