TYPO3 Core

When you are using language overlays and you have an untranslated entity with multiple related FileReference objects the lookup of the overlay FileReference objects is very slow. The following index significantly speeds this up:

CREATE TABLE sys_file_reference (
    KEY localization_parent (pid,sys_language_uid,l10n_parent)
);

I think it would be safe to include this additional index by default.