How to push changes to already deployed db?
I have an already deployed db on cockroach db and I have added the index for one filed in atable schema. Now I want to push the changes so that index is added. How can I do this.
I read the docs and it said not to use the
push
for production environment.1 Reply
I tried
npx prisma migrate dev --name migration-name --create-only
but I still get the error that data will be lost
I just wan to add index to the issuedAt filed so that queries are faster
alright I added teh index will this improve the query result since there is already data in teh table will teh indexes be created for the past data?