Published: 2026-11-21 · Java & Web Architecture Archive

Composite B-Tree Index Ordering: Equality Before Range

Place equality predicates first and range predicates last in composite B-Tree indexes so the query planner can narrow the scan window immediately.

Related: JDBC pool sizing.