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

huonw.github.io

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

huonw.github.io

codeinabox@programming.dev to

SQL@programming.devEnglish · 1 month ago

A sorted-table mental model explains vast differences in performance for similar queries involving only one of a multi-column index in a database.

You must log in or # to comment.

Chat

SQL@programming.dev

sql@programming.dev

Create a post

You are not logged in. However you can subscribe from another Fediverse account, for example Lemmy or Mastodon. To do this, paste the following into the search field of your instance: [email protected]

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

Visibility: Public

This community can be federated to other instances and be posted/commented in by their users.

3 users / day
3 users / week
3 users / month
23 users / 6 months
1 local subscriber
1.79K subscribers
32 Posts
24 Comments
Modlog