title: What is internal working of db2 for comparing strings
body: <p>What is internal working of db2 for comparing strings ?</p>
  
  <p>i have a query</p>
  
  <blockquote>
    <p>select * from mytab where name='rohit'</p>
  </blockquote>
  
  <p>how name in each row is compared to value 'rohit'</p>
  
  <p>I am also thinking to have a column having hash code for each name(varchar) column having index on it. so whenever i look for a name, i should be looking for hashcode instead.</p>
  
  <p>is this approach feasible and can gain performance?</p>