refactor: optimize identity related indices #4919

Job	Run time
Generate SDKs	3m 31s
Run tests and lints	3m 39s
Run Playwright end-to-end tests (postgres)	6m 24s
Run Playwright end-to-end tests (cockroach)	38m 4s
Run end-to-end tests (postgres)	45m 9s
Run Playwright end-to-end tests (sqlite)	37m 40s
Run end-to-end tests (cockroach)	5h 24m 2s
Run Playwright end-to-end tests (mysql)	4m 47s
Run end-to-end tests (sqlite)	2h 1m 22s
Run end-to-end tests (mysql)	8m 6s
Build CLI docs	0s
Generate changelog	1s
Generate release	1s
Release SDKs	1s
Render version schema	1s
Draft newsletter	1s
Pending approval Slack notification	1s
Send newsletter	1s
	9h 52m 51s

Provide feedback