An Index Scan Is Only Half the Story
Comments
Ranked by a public rubric, not by votes: what a comment adds counts, not who wrote it. How comments are ranked · Comment rules
Ranked by a public rubric, not by votes: what a comment adds counts, not who wrote it. How comments are ranked · Comment rules
Summary
In a Microsoft Tech Community post, Microsoft's Azure PostgreSQL team describes a migrated query that was slow only after cache eviction, despite using the same index.