Just upgraded to 4.7.23 and am receiving a Performance Warning: Missing Indices.
The warning states:
The following tables have an index key with a mismatch in value. Please delete the key indices listed from the below table and then click on 'Update Indices' button.
Then the following is listed
Table Name - civicrm_case_contact
Key Name - UI_case_contact_id
Fields - case_id, contact_id
I found the Table in my database with phpMyAdmin. Nested inside are Columns and Indexes. Inside Indexes is what looks like the Key Name of: UI_case_contact_id, and also something labeled: FK_civicrm_case_contact_id.
Will simply deleting UI_case_contact_id resolve this issue?
Or, do I need to delete the Field: FK_civicrm_case_contact_id?
Or is there another approach?
My Civi is definitely slower so looking to see resolving this would help.
Attached an image of the Table from PhpMyAdmin
Thanks in advance