title: Create materialized view much slower than create table
body: <p>I've got a query that I'd like to use to back a materialized view.</p>
  
  <p>When I use this syntax to create a regular table from the view, it executes very quickly (5 seconds):</p>
  
  <pre><code>create table my_table as select * from my_view;
  </code></pre>
  
  <p>However, when I try to create the materialized view from the same view, it's MUCH slower (5+ minutes).</p>
  
  <pre><code>create materialized view my_materialized_view refresh complete start with sysdate next trunc(sysdate, 'HH') + (1/24)  AS select * from my_view;
  </code></pre>
  
  <p>I've already optimized the view query as much as possible.  Selecting directly from the view is quick, as well as creating any number of tables from the view.  It's only after I pass it through create materialized view.</p>
  
  <p>Any ideas what could be causing the slowdown?  Anything I can do (hints, etc) to help it execute quicker when creating the materialize view?</p>