title: Oracle join optimization
body: <p>I have the following SQL query:</p>
  
  <pre><code>select dres.colA, 
         dres.colP, 
         dres.ID,
         dre.ID, 
         dre.colED, 
         dre.VID,
         vpp.VID, 
         vpp.colDESC
  from table1 dres
    left join table2 dre on dres.ID = dre.ID
    left join table3 vpp on vpp.VID = dre.VID    
  where dre.START_TIME &gt;=  date '2017-01-01';
  </code></pre>
  
  <p>Do you have any suggestion how the query can work better (or should look)?
  Something like:</p>
  
  <pre><code>...where dres.ID in (select * from table2 
                       where VID in (select * from table3))....
  </code></pre>