Make an index invisible to test a drop

ALTER TABLE orders ALTER INDEX idx_legacy_status INVISIBLE;
-- run for a week, then:
ALTER TABLE orders DROP INDEX idx_legacy_status;
-- or, if something broke:
ALTER TABLE orders ALTER INDEX idx_legacy_status VISIBLE;