Debug: FK Added Without Supporting Index

Interviewer prompt: Deleting parent rows is now timing out after adding child FK. ALTER TABLE order_items ADD CONSTRAINT fk_order_items_order FOREIGN KEY (order_id) REFERENCES orders(order_id); What SQL fix is missing?