title: DB2 concat vs double pipe
body: <p>Which one of this two views require less CPU?</p>
  
  <p>I'm currently checking the sentences of some views and need to know if there is some performance improvement if concat functions are replaced by double pipes.</p>
  
  <pre><code>create view VIEW1 as
  select concat(concat(concat(concat(concat(concat(concat(concat(concat(A, B),C),D),E),F),F),G),H),I) from TABLE
  
  create view VIEW2 as
  select A||B||C||D||E||F||G||H||I from TABLE
  </code></pre>