Required Appropriate query to find out the result <p>I need a desired result with the less number of execution time. I have a table which contains many rows (over 100k) , in this table a field name is notes varchar2(1800). It contains following values:</p> <pre><code>notes CASE Transfer Surnames AAA : BBBB Case Status ACCOUNT TXFERRED TO BORROWERS Completed Date 25/09/2022 Task Group 16 Message sent at 12/10/2012 11:11:21 Sender : lynxfailures123@google.com Recipient : LFRB568767@yahoo.com Received : 21:31 12/12/2002 </code></pre> <p>Rows should return with the values of(ACCOUNT TXFERRED TO BORROWERS).</p> <p>I have used the following queries but it takes a long time(72150436 sec) to execute:</p> <ol> <li><p><code>Select * from cps_case_history where (dbms_lob.instr(notes, 'ACCOUNT TFR TO UFSS') &gt; 1)</code></p></li> <li><p><code>Select * from cps_case_history where notes like '%ACCOUNT TFR TO UFSS%'</code></p></li> </ol> <p>Could you please share us the exact query which will take less time to execute.</p>