GoThread
appearance log in
home all local communities
c/sql@programming.dev

SQL

log in to join
follow from another instance

Not on this instance? Enter your own instance's domain to go straight to following c/sql@programming.dev there.

hashtags

#sql
0
c/sql@programming.dev · codeinabox@programming.dev · 23 Mar 2026 12:21

Why don't multi-column indices help queries on the second column?

#sql
Why don't multi-column indices help queries on the second column? A sorted-table mental model explains vast differences in performance for similar queries involving only one of a multi-column index in a database. huonw.github.io

check post at origin

0 comments

0 comments

log in to comment.

about

Related Fediverse communities:

  • #sql on Mastodon
  • #postgresql on Mastodon
  • c/PostgreSQL on programming.dev

Icon base by Delapouite under CC BY 3.0 with modifications to add a gradient

members
1929
posts
29
created
15 Jun 2023
active / week
0
active / month
0

moderators

  • @Ategon@programming.dev
  • @jnovinger@programming.dev

rss · modlog

GoThread · self-hosted threadiverse · instances · modlog · rss · appearance · AGPL-3.0