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.
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.