diff options
| author | Frank Karlitschek <frank@owncloud.org> | 2013-11-15 01:25:59 -0800 |
|---|---|---|
| committer | Frank Karlitschek <frank@owncloud.org> | 2013-11-15 01:25:59 -0800 |
| commit | 54364f172e4cdb094497fc6db8f0a71a77d11362 (patch) | |
| tree | 39dacde7d17b40ee8f11d1d21f1fdcc4f8603a51 | |
| parent | 1e863cd95933c77f35004ea02742d23cc74d2003 (diff) | |
| parent | c5cd0b2d262cd502823b0bcd20c04b1d2cf7c277 (diff) | |
| download | nextcloud-server-54364f172e4cdb094497fc6db8f0a71a77d11362.tar.gz nextcloud-server-54364f172e4cdb094497fc6db8f0a71a77d11362.zip | |
Merge pull request #5814 from owncloud/add-indexes
Add some more indexes to tables to improve db queries
| -rw-r--r-- | db_structure.xml | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/db_structure.xml b/db_structure.xml index a41892e39e7..377363b7eea 100644 --- a/db_structure.xml +++ b/db_structure.xml @@ -853,6 +853,24 @@ </field> <index> + <name>item_share_type_index</name> + <field> + <name>item_type</name> + <sorting>ascending</sorting> + </field> + <field> + <name>share_type</name> + <sorting>ascending</sorting> + </field> + </index> + <index> + <name>file_source_index</name> + <field> + <name>file_source</name> + <sorting>ascending</sorting> + </field> + </index> + <index> <name>token_index</name> <field> <name>token</name> @@ -1073,6 +1091,18 @@ </field> </index> + <index> + <name>vcategory_objectd_index</name> + <field> + <name>objid</name> + <sorting>ascending</sorting> + </field> + <field> + <name>type</name> + <sorting>ascending</sorting> + </field> + </index> + </declaration> </table> |