feat: optimize identity-related secondary indices (#4182) #4951

Job	Run time
Generate SDKs	3m 36s
Run end-to-end tests (postgres)	44m 10s
Run tests and lints	29m 46s
Run end-to-end tests (cockroach)	46m 0s
Run Playwright end-to-end tests (postgres)	6m 30s
Run end-to-end tests (sqlite)	44m 34s
Run Playwright end-to-end tests (cockroach)	6m 45s
Run end-to-end tests (mysql)	44m 26s
Run Playwright end-to-end tests (sqlite)	6m 4s
Run Playwright end-to-end tests (mysql)	6m 13s
Build CLI docs	1m 11s
Generate changelog	56s
Generate release	0s
Render version schema	0s
Release SDKs	0s
Draft newsletter	0s
Send newsletter	0s
Pending approval Slack notification	0s
	4h 0m 11s

Provide feedback