sql server performance
which one affect affect the query performance large number of columns or large number of rows?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jignesh TrivediPosted Jul 23, 2012, 12:07 AM
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.