DanTheGoodmanD
Convex Community7mo ago
3 replies
DanTheGoodman

Index with compound keys - can you use part of the key?

For something like

export default defineSchema({
  messages: defineTable({
    channel: v.id("channels"),
    body: v.string(),
    user: v.id("users"),
  })
    .index("by_channel", ["channel"])
    .index("by_channel_user", ["channel", "user"]),
});


Does that
by_channel
need to exist? Can we not use just the
channel
first key of the
by_channel_user
index?
Was this page helpful?