Retrieving latest record using DISTINCT ON is slow
42491
How do I efficiently get "the most recent corresponding row"?
103080
slow query with fulltext and left join
144830
How to select the most recent set of dated records from a mysql table
96218
Using Distinct with LINQ and Objects
112338
Why is PostgreSQL 9.5 not using my newest index for ORDER BY, even though it uses similar indices just fine?
99497
IF EXISTS taking longer than embedded select statement
22985
SQL query that gives distinct results that match multiple columns
139963
How to query More than 50000 records from sObject
153741
how to select the 5 latest row from my mysql
143698
Why my sql query run faster than my stored procedure?
89441
Reduce query time for higher offset in sql server
116838
Query runs slow with date expression, but fast with string literal
21145
Return more than 2000 records (SOQL)
155018
Use of Distinct with list of custom objects
115519
How can "set timestamp" be a slow query?
19952
Counting DISTINCT over multiple columns
152542
Query extremely slow in code but fast in SSMS