Scenario: Recover from Dropped Index

Interviewer prompt: A critical index was dropped accidentally and latency spiked. What immediate SQL actions would you take?

orders(order_id, customer_id, order_ts, status)