NextCloud

h3. 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:

<pre>

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

</pre>

For a non-interactive process, use:

<pre>

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

</pre>

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.