title: Performance issue with varchar2 2000 byte column in oracle
body: <p>i have a column that is varchar2 (2000 bytes), this is an existing column and is being used in many places, the issue is when i am trying to compare with this column the query is taking 30-40 seconds to execute. the query is as simple as below-</p>
  
  <pre><code>select response_id from t_response where desc_response = to_char(1000);
  </code></pre>
  
  <p><code>desc_response</code> is that column.</p>
  
  <p>i found that we have only one index as of now on this table and that is on response_id column.</p>