Top 10 SQL server Performance tuning tips - 7

Wednesday 9 September 2009

Remove unwanted columns from the SELECT statement

In queries, don't return column data you don't need. For example, you should not use SELECT * to return all the columns from a table if you don't need all the data from each column. In addition, using SELECT * may prevent the use of covered indexes, further potentially affect query performance.