SQLD 기출문제 예상문제 201번

다음 문제를 풀어보세요.

다음 중 아래 SQL 쿼리의 성능 개선을 위해 생성할 수 있는 가장 효율적인 인덱스를 고르시오.

SELECT order_id, customer_id, order_date
FROM orders
WHERE customer_id = 123
AND order_date BETWEEN '2023-01-01' AND '2023-03-31'
ORDER BY order_date DESC;

-- orders 테이블 구조 예시
CREATE TABLE orders (
    order_id INT PRIMARY KEY,
    customer_id INT,
    order_date DATE,
    order_amount DECIMAL(10, 2)
);

CREATE INDEX idx_customer_id ON orders (customer_id);

CREATE INDEX idx_order_date ON orders (order_date);

CREATE INDEX idx_customer_id_order_date ON orders (customer_id, order_date);

CREATE INDEX idx_order_id ON orders (order_id);