title: SQL Server: Index columns used in like?
body: <p>Is it a good idea to index varchar columns only used in LIKE opertations? From what I can read from query analytics I get from the following query:</p>
  
  <pre><code>SELECT * FROM ClientUsers WHERE Email LIKE '%niels@bosmainter%'
  </code></pre>
  
  <p>I get an "Estimated subtree cost" of 0.38 without any index and 0.14 with an index. Is this a good metric to use for anlayzing if a query has been optimized with an index?</p>