#89846Missing database indices
Description
While checking https://review.typo3.org/c/Packages/TYPO3.CMS/+/62532 I found some more missing indices.
I’ll happily take care of this and keep this open until the release of 10 LTS.
Minimal test setup:
# use introduction package as test base
composer req typo3/cms-introduction
ddev exec -s db sh <<< "mysql -e 'SET GLOBAL log_queries_not_using_indexes=ON;'"
ddev logs -s db -f
# crawl frontend
wget \
-nv -e robots=off -R.css,.js,.jpg,.png,.pdf -nd -r \
--delete-after --level=5
# run backend acceptance tests (mariadb)
/Build/Scripts/runTests.sh -s acceptance
# run functional tests with different DB systems # ignores mssql|postgres|sqlite
/Build/Scripts/runTests.sh -s functional mariadb
/Build/Scripts/runTests.sh -s functional mysql55