Parodia
  • Communities
  • Multi-communities
  • Support Lemmy
  • Search
  • Login
  • Sign Up
SQL@programming.devbycodeinabox@programming.dev
5 months

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

huonw.github.io English
0
    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.

    SQL@programming.dev

    sql@programming.dev

    Subscribe from remote instance

    Create post

    Report community

    Modlog
    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 is visible to everyone.

    • 0 users / Day
    • 5 users / Week
    • 6 users / Month
    • 6 users / 6 months
    • 8 posts
    • 0 comments
    • 0 local subscribers
    • 1.86K subscribers
    • Mods:
    • Ategon@programming.dev
    • BE: 1.0.0-beta.1
    • Modlog
    • Legal
    • Instances
    • Docs
    • Code
    • join-lemmy.org