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