title: Should I try stop Implicit Conversion?
body: <p>I have a table that is in a database I am not allowed to edit as it belongs to a third party. They have a field with datatype Char(2) this fields holds the following values:</p>
  
  <pre><code>01
  02
  03
  04
  </code></pre>
  
  <p>I also have several other tables both physical and temp that have this same field and values. I am working on making a massive table that combines data between these tables. However when I run the code with just selecting that field not doing anything to it the execution plan does an implicit conversion to int.</p>
  
  <p>I do not care that the field is int as that makes more sense to me anyways but the execution plan also states that the conversion </p>
  
  <pre><code>"may affect cardinality estimate"
  </code></pre>
  
  <p>I am having issues with this code running slow and was thinking this might be the problem. </p>
  
  <p>Should I try to find a way to stop the conversion or is it likely not causing my slow down?</p>
  
  <p>Edit:
  Extra info this column is used in joins</p>
  
  <p>Let me know if you need more info. </p>
  
  <p>Using SQL 2012</p>