Shouldn't there always be an Index on the @id field? Seems like a lot of my tables in db is missing them... Why?

https://www.prisma.io/docs/concepts/components/prisma-schema/indexes might help.

As far as I’m aware, an index is automatically created for a primary key. So, that’s why it might not be visible in the DB itself, but as long as the

PRIMARY KEY

is there, you’re safe in that the column has an index as well 👍

thx 🙂