- The database is missing some indexes. Due to the fact that adding indexes on big tables could take some time they were not added automatically. By running “occ db:add-missing-indices” those missing indexes could be added manually while the instance keeps running. Once the indexes are added queries to those tables are usually much faster.
- Missing index “preferences_app_key” in table “oc_preferences”.
I’m unsure how to sudo to this on nextbox to add the missing index’s, does anyone have the code?