0
Possible DB indexes
Source: nextcloud/server#10926 · opened by @rullzer
Possible DB indexes: - [ ] ALTER TABLE oc_cards ADD INDEX z_oc_cards (uri), ALGORITHM=INPLACE, LOCK=NONE;
• ALTER TABLE oc_cards ADD INDEX z_oc_cards_add_uri (addressbookid,uri), ALGORITHM=INPLACE, LOCK=NONE;
• ALTER TABLE oc_cards_properties ADD INDEX z_oc_cards_properties_add (addressbookid), ALGORITHM=INPLACE, LOCK=NONE;
• ALTER TABLE oc_filecache ADD INDEX z_oc_filecache_par_stor (parent,storage), ALGORITHM=INPLACE, LOCK=NONE;
• ALTER TABLE oc_filecache ADD INDEX z_oc_filecache_parent (parent), ALGORITHM=INPLACE, LOCK=NONE;
• ALTER TABLE oc_filecache ADD INDEX z_oc_filecache_par_st_sz (parent,storage,size), ALGORITHM=INPLACE, LOCK=NONE;
• ALTER TABLE oc_jobs ADD INDEX z_oc_jobs_reserved_at (reserved_at), ALGORITHM=INPLACE, LOCK=NONE;
• ALTER TABLE oc_share ADD INDEX z_oc_share_uid_ini (uid_initiator ), ALGORITHM=INPLACE, LOCK=NONE;
• ALTER TABLE oc_cards ADD INDEX z_oc_cards_add_uri (addressbookid,uri), ALGORITHM=INPLACE, LOCK=NONE;
• ALTER TABLE oc_cards_properties ADD INDEX z_oc_cards_properties_add (addressbookid), ALGORITHM=INPLACE, LOCK=NONE;
• ALTER TABLE oc_filecache ADD INDEX z_oc_filecache_par_stor (parent,storage), ALGORITHM=INPLACE, LOCK=NONE;
• ALTER TABLE oc_filecache ADD INDEX z_oc_filecache_parent (parent), ALGORITHM=INPLACE, LOCK=NONE;
• ALTER TABLE oc_filecache ADD INDEX z_oc_filecache_par_st_sz (parent,storage,size), ALGORITHM=INPLACE, LOCK=NONE;
• ALTER TABLE oc_jobs ADD INDEX z_oc_jobs_reserved_at (reserved_at), ALGORITHM=INPLACE, LOCK=NONE;
• ALTER TABLE oc_share ADD INDEX z_oc_share_uid_ini (uid_initiator ), ALGORITHM=INPLACE, LOCK=NONE;
No pledges yet. Be the first to back this.
No comments yet.