Sto give you a decent summary but without going in full detail unless you want me to: you use an ind
to give you a decent summary but without going in full detail unless you want me to:
you use an index kind of how you use a book mark, you save that spot to get back to it later,
You basically tell the database: hey, I need you to search this table quickly by choosing the "index" as a marker.
Technical wise, you would use it based on your needs, you need a to find the user/s with the name having "sara"? you would index the table with
I think the docs have it better than my example,
https://docs.convex.dev/database/reading-data/indexes/
further questions, we are happy to help in #support-community
you use an index kind of how you use a book mark, you save that spot to get back to it later,
You basically tell the database: hey, I need you to search this table quickly by choosing the "index" as a marker.
Technical wise, you would use it based on your needs, you need a to find the user/s with the name having "sara"? you would index the table with
index("by_name", ["name"])index("by_name", ["name"]), you want to find all users having sara and are aged less than 20? you use something like index("by_name_age", ["name", "age"])index("by_name_age", ["name", "age"]) and you can easily find it using a mix of withIndex("by_name_age", (q)=>q.eq("name", name).lte("age", 20))withIndex("by_name_age", (q)=>q.eq("name", name).lte("age", 20))I think the docs have it better than my example,
https://docs.convex.dev/database/reading-data/indexes/
further questions, we are happy to help in #support-community
