T-SQL Performance Tip: 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.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

More From DevX