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 DevX Tip Bank

?

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

Related Posts