title: Join takes too long
body: <p>I have this query that takes about 5 minutes to run in Oracle:</p>
  
  <pre><code>select t1.A,t2.B,t2.C,t2.D,t2.E 
  from TABLE1 t1 join TABLE2 t2 
  on t2.X = t1.Y 
  where t1.F = &lt;integer&gt; 
  and t2.G = &lt;integer&gt; 
  and t1.H = &lt;integer&gt; 
  </code></pre>
  
  <p>t1 has 1.7 million rows and t2 has 31 million. I have indices on t2.X and t1.F. Tried adding indices on t1.Y, t2.G and t1.H but they didn't help. Any ideas how I can improve performance of this join?</p>