Is "SELECT COUNT(column)" faster/slower than "SELECT COUNT(*)"?
34833
COUNT(*) vs. COUNT(1) vs. COUNT(pk): which is better?
86298
How do I (or can I) SELECT DISTINCT on multiple columns?
67587
Fast way to discover the row count of a table in PostgreSQL
151604
Why does a query run slower in a Stored Procedure than in the Query window?
148599
"Column count doesn't match value count at row" but it does
59344
What is the default order of records for a SELECT statement in MySQL?
54760
MySQL INSERT INTO SELECT vs BULK INSERTs performance
75971
Is there a PL/SQL pragma similar to DETERMINISTIC, but for the scope of one single SQL SELECT?
138284
Are individual queries faster than joins?
11315
Select query takes more time than it should
83242
How to get count for different columns on same table
22982
Most efficient way to call same Table-Valued Function on multiple columns in a Query
110561
Count property vs Count() method?
75366
Why is SELECT * considered harmful?
17662
What is the fastest way to insert large numbers of rows?
127553
Why is this MySQL SELECT performing so slowly despite indexing?
86609
Is a view faster than a simple query?