title: Performance : Left JOIN with IS NULL join condition in SQLite
body: <pre><code>select *
  from Dummy LEFT JOIN data_stream_2
      ON ((Dummy.id_2=data_stream_2.id_2) OR
         (Dummy.id_2 IS NULL and data_stream_2.id_2 IS NULL))
  </code></pre>
  
  <p>This query takes 26 seconds. The moment I remove the IS NULL check, i.e</p>
  
  <pre><code>select *
  from Dummy LEFT JOIN data_stream_2
      ON ((Dummy.id_2=data_stream_2.id_2))
  </code></pre>
  
  <p>it takes only 1.3 seconds.
  How can I make the query faster?
  It us similar to this case <a href="https://stackoverflow.com/questions/1069704/slow-query-with-left-outer-join-and-is-null-condition">Slow query with left outer join and is null condition</a> but the difference is in his case join was not really required since he was using only columns from Dummy and not from data_stream_2. I need columns from both.</p>