query: Execution time select * vs select count(*)
positive_passages.docid: 18781
positive_passages.text: SQL count(*) performance
negative_passages.docid: 94106
negative_passages.text: T-SQL Insert - Select in Table variable is very slow
negative_passages.docid: 53417
negative_passages.text: Calculate execution time of a SQL query?
negative_passages.docid: 78477
negative_passages.text: Most efficient way to get table row count
negative_passages.docid: 13678
negative_passages.text: 'SELECT TOP' performance question
negative_passages.docid: 136720
negative_passages.text: What does OPTION FAST in SELECT statement do?
negative_passages.docid: 81517
negative_passages.text: Is there a concurrency with UPDATE count=count+1?
negative_passages.docid: 68213
negative_passages.text: pure functions in nested select
negative_passages.docid: 55584
negative_passages.text: select * vs select column
negative_passages.docid: 41314
negative_passages.text: Is there a REAL performance difference between INT and VARCHAR primary keys?
negative_passages.docid: 149623
negative_passages.text: How to improve the performance of this select query?
negative_passages.docid: 128013
negative_passages.text: count() returns a different amount than a simple select
negative_passages.docid: 52166
negative_passages.text: SELECT COUNT(*) AS count - How to use this count
negative_passages.docid: 37605
negative_passages.text: How to output result of SELECT statement which is executed using native dynamic SQL?
negative_passages.docid: 56572
negative_passages.text: Which method performs better: .Any() vs .Count() > 0?
negative_passages.docid: 108832
negative_passages.text: Is a join optimized to a where clause at runtime?
negative_passages.docid: 123923
negative_passages.text: Why is query choosing horrible execution plan?