Prevent order by created_at and id
As part of !86104 (merged) we discovered that ordering by both id
and created_at
can produce very poor query results. Ordering by both created_at
and id
is redundant. There is already a recommendation from the database team to sort by id
rather than created_at
.
We should prevent queries, sub-queries, and CTEs to order by both id
and created_at
.
Edited by Alex Pooley