title: SQL select statement with either ( * ) or (fields names) which performs better?
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/65512/which-is-faster-best-select-or-select-column1-colum2-column3-etc">Which is faster/best? SELECT * or SELECT column1, colum2, column3, etc.</a>  </p>
  </blockquote>
  
  
  
  <pre><code>SELECT * FROM tbl1 
  </code></pre>
  
  <p>and </p>
  
  <pre><code>SELECT field1, field2,...... FROM tbl1
  </code></pre>
  
  <p>how does <code>SQL engine</code> execute the previous two select statements (step by step) and which one performs better?</p>