SQL Query Question - Select * from view or Select col1,col2.....from view
- by Napco
We are using SQL2005 but this question can be for any rdbms.
Which is more efficient, when selecting all columns from a view
Select * from view
or
Select col1,col2.....from view