title: dbms_lob.instr Takes a very very long time to fetch the data
body: <p>We store clob data in the database in XML format and the data type is CLOB.</p>
  
  <p>So to get this data we try the use the following query:</p>
  
  <pre><code>select message_xml
    from table
   where dbms_lob.instr(message_xml, 'A12345678') &gt; 0
   order by message_date;
  </code></pre>
  
  <p>But this query takes a very long time around an hour or more to give me the result.</p>
  
  <p>Is there a better way to do this.</p>
  
  <p>Kindly note that I am firing the query in Oracle 11g database.</p>