refactor: optimize identity related indices #4923

Job	Run time
Generate SDKs	3m 29s
Run tests and lints	14m 12s
Run end-to-end tests (postgres)	43m 37s
Run Playwright end-to-end tests (postgres)	6m 4s
Run end-to-end tests (cockroach)	44m 12s
Run Playwright end-to-end tests (cockroach)	6m 22s
Run end-to-end tests (sqlite)	44m 11s
Run Playwright end-to-end tests (sqlite)	6m 0s
Run end-to-end tests (mysql)	44m 6s
Run Playwright end-to-end tests (mysql)	6m 10s
Build CLI docs	0s
Generate changelog	1s
Generate release	1s
Draft newsletter	1s
Render version schema	1s
Release SDKs	1s
Send newsletter	1s
Pending approval Slack notification	1s
	3h 38m 30s

Provide feedback