title: Oracle - xmlindex slows down the insert operation
body: <p>Scenario - I have created XMLINDEX on a table to speed up my Select query.</p>
  
  <p>Now, Select query becomes very fast.
  However, Insert operation to the table becomes very slow.</p>
  
  <p>I cant make the index unusable at the time of data loading because at the same time Select query could run and need xmlindex.</p>
  
  <p>I tried no_index and few xmlindex hints but every time it was slow. If I make the xmlindex unusable then of course, my insert completes in &lt;1 secs.</p>
  
  <p>Is there any way to load the data by keeping xmlindex? Like any hint?</p>
  
  <p>Sample insert script:</p>
  
  <pre><code>insert into table_xml -- this table has xmlindex, here i dont want to use xmlindex
  
  select * from some_other_table;
  -----------------------------------------------
  select * from table_xml, xmltable (...); -- here xmlindex is giving great performance
  </code></pre>