SQL Query Question - Select * from view or Select col1,col2.....from view
Posted
by Napco
on Stack Overflow
See other posts from Stack Overflow
or by Napco
Published on 2008-09-24T17:08:22Z
Indexed on
2010/05/08
6:28 UTC
Read the original article
Hit count: 157
Filed under:
sql
|sql-server
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
© Stack Overflow or respective owner
