title: Fast update query on millions table
body: <p>I'm updating a table with million records with a simple query but its taking huge timimg, wondering if someone could bring some magic with alternative to speed the process query bellow</p>
  
  <pre><code>UPDATE sources.product
     SET partial=left(full,7);
  </code></pre>