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 · 7 months 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 register 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: !sql@programming.dev

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.

15 users / day
15 users / week
15 users / month
15 users / 6 months
0 local subscribers
1.89K subscribers
29 Posts
0 Comments
Modlog