title: SQL query - Select * from view or Select col1, col2, ... colN from view
body: <p>We are using SQL Server 2005, but this question can be for any <a href="http://en.wikipedia.org/wiki/Relational_database_management_system" rel="noreferrer">RDBMS</a>.</p>
  
  <p>Which of the following is more efficient, when selecting all columns from a view?</p>
  
  <pre><code>Select * from view 
  </code></pre>
  
  <p>or </p>
  
  <pre><code>Select col1, col2, ..., colN from view
  </code></pre>