sql server performance

Question

which one affect affect the query performance large number of columns or large number of rows?

Jignesh Trivedi · Answer

hi Gopinath Both will affect Query performance. I think spcify column name insted of use * retrieve only those column which you really required. http://beginner-sql-tutorial.com/sql-query-tuning.htm http://www.infoworld.com/d/data-management/7-performance-tips-faster-sql-queries-262 hope this will help you.