hey yall! where can i read about using indexes in ...
# orm-help
s
hey yall! where can i read about using indexes in conjunction with Prisma?  Is it possible to optimize deeply nested Prisma queries using indexes? I'm using MySQL btw
👋🏾 1
👋 1
r
@Spencer Curry 👋 You should be able to add indexes via Prisma Migrate in the generated
.sql
files. Then querying with the correct filters should automatically use those indexes.
j
There is no deep control about the indexes used - usually the DBMS is quite good about that.
If you have a specific use case, please open an issue and we can think how we could integrate that in Prisma.
As far as I know there is no issue like that yet, so there does not seem to be much demand for it in general.