title: SQL: adding "not in" slows the SQL command
body: <p>Adding "not in" statement to my SQL command makes the whole thing extremely slow. Any suggestion on how to get around this would be greatly appreciated!</p>
  
  <pre><code>select distinct 
      d.fiscal_year,d.calendar_year,d.month_num
  from vw_ePCR_eMeds_tickets v
      inner join incident_date_dim d on v.ticketdos=d.inci_date
      left join vw_all_incidents i on i.CADIncidentNumber=v.incident_num
  where TicketDOS between  '12/01/2017' and '05/31/2018'
      and [transportedstatus] = 'transported'
      and i.call_type_id  not in (
          select call_type_id
          from DW_EMS_Elite.dbo.MCFRS_EMS_BillingExclude 
      )
  </code></pre>