Tip: T-SQL Performance–The * Operator
It is best to avoid using the * operator in your queries, use explicit column names instead. SQL Server scans through all column names and replaces the * operator with all the column names of the tables. ? Visit the
