Folks, a question: Prisma has support the ability to specify which index type should be used? cause it seems Prisma doesn't allow to define which type of Primary Key one can use, and it default to a CLUSTERED index to support the primary key, which is best when data is ordered, but the UUID generate data with random order. Question: in this case an INT with an autoincrement() attribute would be better? cc: @Alex Ruheni @nikolasburk

What kind of index (SQL) would you be looking for instead? Generally Prisma does not take a stance there, we "just" create a Primary Key. The database does the rest by default. Maybe that needs to be adapted?

I'll be reaching out Davide Mauri (PM Azure SQL)

Awesome. As soon as we have a bit more information here, I am sure we can give a better answer.