NextCloud

Missing indexes¶

If Nextcloud has identified missing database indexes, which can improve query performance, you can up them, however due to the potential time required to add indexes to large tables, this process was not done automatically.

To manually add the missing indexes while the instance remains operational, run the following command:

sudo -u www-data php occ db:add-missing-indices

For a non-interactive process, use:

sudo -u www-data php occ db:add-missing-indices --no-interaction

An example of a missing index is "mounts_class_index" in the "oc_mounts" table. Once the indexes are added, queries to these tables should execute faster.