dcsimg
LinkedIn
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Tip: T-SQL Performance--The * Operator

Learn more about why you should use explicit column names in T-SQL.


advertisement

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

 



   
Email AuthorEmail Author
Close Icon
Thanks for your registration, follow us on our social networks to keep up-to-date