-- Oracle does not support `IF NOT EXISTS` syntax when creating indexes.
-- You should review your database for any of the indexes described here that pre-exist,
-- and omit them from what you apply to your Oracle database.

CREATE INDEX IDX84931J3O4L72ECHAFHVL5B396 ON BLC_SAVED_PAYMENT_METHOD(ORIGINATING_PAYMENT_ID) ONLINE;
CREATE INDEX IDX9F7EW6ENFHJ96ITUHK8U12N4I ON BLC_SAVED_PAYMENT_METHOD(OWNING_USER_ID) ONLINE;
CREATE INDEX IDXTJVIKDATAT8ETRNQK13YQXFDF ON BLC_PAYMENT_TRANSACTION(REQUEST_ID) ONLINE;
CREATE INDEX IDXVSRMTLEJ61UXHX0YIWPB2RCRV ON BLC_NOTIFICATION_STATE(ACKED, STOPPED, NOTIFICATION_NAME, CHANGE_TIMESTAMP, NEXT_ATTEMPT) ONLINE;