如何使用subselect for Firebird优化SQL delete查询？

DELETE FROM orders
WHERE order_id NOT IN (
    SELECT order_id FROM customers_orders
);

DELETE FROM orders
WHERE order_id NOT IN (
    SELECT order_id FROM customers_orders
)
WHERE order_id BETWEEN 1 AND 1000;

CREATE TEMPORARY TABLE temp_orders AS
SELECT order_id FROM customers_orders;

DELETE FROM orders
WHERE order_id NOT IN (SELECT order_id FROM temp_orders);

-- 创建示例表
CREATE TABLE customers_orders (
    order_id INT PRIMARY KEY,
    customer_id INT
);

CREATE TABLE orders (
    order_id INT PRIMARY KEY,
    order_date DATE
);

-- 插入示例数据
INSERT INTO customers_orders VALUES (1, 101);
INSERT INTO customers_orders VALUES (2, 102);
INSERT INTO orders VALUES (1, '2023-01-01');
INSERT INTO orders VALUES (2, '2023-01-02');
INSERT INTO orders VALUES (3, '2023-01-03');

-- 使用子查询优化DELETE操作
DELETE FROM orders
WHERE order_id NOT IN (
    SELECT order_id FROM customers_orders
);

-- 检查结果
SELECT * FROM orders;