Check for existing/missing indices for things like "parent_item_id"

[Flyingmana]

Source:

• https://www.linkedin.com/posts/yehorshytikov_magento-mysql-enterprise-activity-6689044994386468864-AVWB
• https://www.linkedin.com/feed/update/urn:li:activity:6689044994386468864?commentUrn=urn%3Ali%3Acomment%3A%28activity%3A6689044994386468864%2C6689056427685875712%29

Main Post is about M2, but there were hints it could also be an issue in M1/OpenMage