fix: add missing indexes and remove unused index #3980

Job	Run time
Generate SDKs	1m 10s
Run end-to-end tests (postgres)	8m 16s
Run end-to-end tests (cockroach)	8m 6s
Run end-to-end tests (sqlite)	8m 21s
Run end-to-end tests (mysql)	8m 10s
Run tests and lints	7m 49s
Run Playwright end-to-end tests (postgres)	3m 36s
Run Playwright end-to-end tests (cockroach)	4m 15s
Run Playwright end-to-end tests (sqlite)	3m 37s
Run Playwright end-to-end tests (mysql)	3m 44s
Build CLI docs	0s
Generate changelog	0s
Generate release	0s
Release SDKs	0s
Render version schema	0s
Draft newsletter	0s
Pending approval Slack notification	0s
Send newsletter	0s
	57m 4s

Provide feedback