Most developers treat database indexes like salt: sprinkle a little on every foreign key…
This is a dev post classified by AGK Intelligence as Databases (a tutorial), kept by the Dev Radar because it carries real work, not commentary.
Most developers treat database indexes like salt: sprinkle a little on every foreign key and hope for the best. Then production traffic hits 10k RPM, and query latency falls off a cliff. Here is a 3-minute masterclass on composite indexes to keep your queries under 5ms: 1. The "Equality First, Range Later" Rule (ESR) The order of columns in a multi-column index determines whether the engine uses an Index Scan or a table walk: - Equality (`=`): Place exact match columns first (`status`, `tenant_id`). - Sort (`ORDER BY`): Place sorting columns next. - Range (`>`, `<`, `BETWEEN`, `LIKE`): Put
Posted by Dez | Web Architect & Spiggle Author (754 followers) 1 h ago · 0 likes · 2 views · view the original post on X. Kept by the Dev Radar as Databases.
More dev work like this
- Your Iceberg tables shouldn't be locked into a single catalog. — @databricks
- Bringing Local Analytics to the Quant’s Desktop 🧮 — @duckdb
- Just launched a game on http://pgx.dev 🐘💣 — @alxshp
- HLD Interview Notes: Day 15/30 — @SCR01111
- On Chroma Cloud and looking at Qdrant? Writes stop Nov 22. — @qdrant_engine
- #SQL Commands! #BigData #Analytics #DataScience #AI #MachineLearning #IoT #IIoT #PyTorch… — @gp_pulipaka
- Amazon RedShift Cookbook! #BigData #Analytics #DataScience #AI #MachineLearning #IoT… — @gp_pulipaka
- IronBeetle⚡️ Ep 126 — @TigerBeetleDB
Every post is read and classified by AGK Intelligence: what it is, which market it belongs to, and whether the link is a real tool. 31.2k posts from 5k X accounts over the last 21 days, 9.2k tools, 12 markets. New posts are collected several times an hour and the full ranking is recomputed every hour — last update 2026-11-03 21:07 UTC. Full method.