TYPO3 Core

Hmm. unsure about this index. we have an index (pid, username) already, so pid is covered already. this is probably why the difference as measured by guido is not that big, since "only" deleted is scanned. I think huge fe_users tables with lots of deleted records should be cleaned up regularily anyway ... that table typically contains personal information, so instances should strive to remove old data here anyways, especially if there are many thousands users in it.

An instance that really needs this key, can also just add in in an own ext_tables.sql file.

I'd thus say this key is likely not that useful for standard instances, so I'm going to close the issue for now.