prisma
Index parameter definition in data model
There might be use-cases for our users to define index settings through our data model. This is specific to SQL Server, but a quite common setting is the clustering. The SQL Server documentation has more information what parameters can be given.
We might want to consider giving the user a possibility to define these settings in the data model level, or we might want to even decide the correct index parameter based on their features in the table.
Postgres also has a ton of useful ways to tweak indexing strategies and what exactly gets indexes.
This would not be a engine level, but a schema level change as it needs representation in PSL. An issue in prisma/prisma would be useful (kind/feature, team/product).
