Specify DB columns to be indexed

[marktani]

Currently, for a given model, the id field, all unique fields and all relations are indexed already.

[dubiousdavid]

A real game changer would be if you could specify multiple columns for an index. In particular, a unique index across more than one field allows you to constrain by, for example, userId and name, so that the name field is unique per user, but not globally unique.

[marktani]

Thanks for the suggestion @dubiousdavid, this is related to #65. 🙂

[marktani]

Closing in favor of https://github.com/graphcool/framework/issues/1300. @dubiousdavid would love to hear your feedback on the linked proposal!

[Xample]

@mahkali 404 what is the status of this issue ? I am struggling with very poor performances on text search over a set of 2.5m items… (postgres)

[ehxxn]

So what if I directly manipulate database and set index on it. I think this will not make any issue for prisma service. I hope 🤲