programming.dev
  • Communities
  • Create Post
  • Create Community
  • heart
    Support Lemmy
  • search
    Search
  • Login
  • Sign Up
codeinabox to SQLEnglish · 6 hours ago

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

huonw.github.io

external-link
message-square
0
link
fedilink
3
external-link

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

huonw.github.io

codeinabox to SQLEnglish · 6 hours ago
message-square
0
link
fedilink
A sorted-table mental model explains vast differences in performance for similar queries involving only one of a multi-column index in a database.
alert-triangle
You must log in or # to comment.

SQL

sql

Subscribe from Remote Instance

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
globe

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

  • 3 users / day
  • 7 users / week
  • 7 users / month
  • 22 users / 6 months
  • 252 local subscribers
  • 1.79K subscribers
  • 32 Posts
  • 96 Comments
  • Modlog
  • mods:
  • Ategon
  • Jason Novinger
  • BE: 0.19.13
  • Modlog
  • Legal
  • Instances
  • Docs
  • Code
  • join-lemmy.org