LINKED LIST [txt mode] ▸ 10 Ways to Tweak Slow SQL Queries

home explore | log in

10 Ways to Tweak Slow SQL Queries

helenanderson.co.nz · first added by @afreshcup · 2026-09-30 · 1 upvotes

log in to save, upvote or flag this.

─── In 0 lists ─────────────────────────────────────────

(not in any lists yet)

─── Discussions ────────────────────────────────────────

* Ways to Tweak Slow SQL Queries

281 pts · 62 comments · node

─── From the discussion ────────────────────────────────

* Index INCLUDE Clause: How it works and when to use it

use-the-index-luke.com · node

* Index Columns for `LIKE` in PostgreSQL

niallburkley.com · node

* PgSQL Indexes and

blog.cleverelephant.ca · node

* Waiting for PostgreSQL 12 – Allow user control of CTE materialization, and change the default behavior. – select * from depesz;

depesz.com · node

* eVXI : Bad plan | explain.depesz.com

explain.depesz.com · node