TYPO3 Core

"IMHO" is not a patch and not enough for any practical work. Database indexes is a complex thing and simply including all these fields to index will not work. If you have any real proposal, please, post them. Otherwise this bug report can be closed...

At least deleted and hidden are fields rapitly used within where clauses.
Having them in a e.g Left join clause without beeing indexed dramiticly raises the query s runtime. (e.g left join on x.uid=y.uid and y.hidden=0).

Even if T3 itself does'nt make use of joins internally that much it might make senses anyway.

Regarding the I18l fields: having a huge amount of translation records makes it impossible to follow the T3 philisophie of fetching the default language and fetching the translation by fireing a second query. Therefor such a situation has to be solved by using complex joins for performance reason. In this scenarion the above named fields need to be indices (see left join example)

"Database indexes is a complex thing and simply including all these fields to index will not work."
For what reasons? Could you please explain?