In the context of SQL query performance, explain how you would identify and resolve bottlenecks in a query that joins multiple large tables. Provide specific examples of SQL optimizations that could be applied. Additionally, discuss how the choice of join types (e.g., INNER JOIN, LEFT JOIN) can impact performance.