如何使用多个连接来提高查询性能

I have a query (with the purpose of making a view) which is using a few joins to get each column. Performance degrades quickly (exponentially?) for each set of joins added. I have a query (with the purpose of making a vi