#59809Create better indexes for EM
Description
Hello Core-Team,
I have changed an index for em. Here are the result (before and after)
| 3 | 0.49219400 | SELECT SQL_NO_CACHE extension_key, max(integer_version) as maxintversion FROM tx_extensionmanager_domain_model_extension WHERE repository=1 GROUP BY extension_key | | 4 | 0.17256100 | SELECT SQL_NO_CACHE extension_key, max(integer_version) as maxintversion FROM tx_extensionmanager_domain_model_extension WHERE repository=1 GROUP BY extension_key |
In general I would prefer to remove or move col “repository” to the end of an index
Stefan