What’s the equivalent of DBMS concept of indexes ? If I know have will have a metric ton of "get user by email" requests, in a standard DBMS I will just add an index of the email column. How does Unbounded handle that ?
You can create indexes to match on one or more properties:
https://admin.unbounded.cloud/docs/#/guide?id=configuring-in...
You can also create saved queries to partition the data by more complex criteria: