refactor: optimize identity related indices #4924

Job	Run time
Generate SDKs	3m 27s
Run tests and lints	27m 19s
Run Playwright end-to-end tests (postgres)	6m 22s
Run Playwright end-to-end tests (cockroach)	7m 26s
Run Playwright end-to-end tests (sqlite)	6m 44s
Run Playwright end-to-end tests (mysql)	6m 26s
Run end-to-end tests (postgres)	43m 38s
Run end-to-end tests (cockroach)	47m 52s
Run end-to-end tests (sqlite)	45m 3s
Run end-to-end tests (mysql)	45m 56s
Build CLI docs	0s
Generate changelog	1s
Generate release	1s
Draft newsletter	1s
Render version schema	1s
Release SDKs	1s
Pending approval Slack notification	1s
Send newsletter	1s
	4h 0m 20s

Provide feedback