title: Oracle - JOIN two complex Views - optimizer faults
body: <p>I have two pretty complex views. I need to produce report that will join both by some column.
  Each of views separately returns in less than a minute with complete result set.
  When I join them optimizer rebuilds query and makes weird things so result doesn't return at all.
  The question is whether there is a way to tell the optimizer to retrieve both sets first and only then join them (each set is only some thousands of records).</p>
  
  <p>For time being the solution is based on creating intermediate table (materialized view also worked), but I'd like to do that in single query,</p>
  
  <p>Thank you</p>