DanTheGoodmanD
Convex Community6mo 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?