[SOLVED] Optimize this MS SQL query with a lot of joins

Issue I’m using this query with joins to select specific values from one view: SELECT DISTINCT qir.[Portfolio Company Key] AS portfolio_company_id, qir.[Quarter Date Key] AS quarter_date_id, realized_value.Value AS realized_value, unrealized_value.Value AS unrealized_value, total_fair_value.Value as total_fair_value, multiple.Value as multiple, gross_irr_percentage.Value as

Continue reading