SQLP CBT 기출문제 예상문제 455번

다음 문제를 풀어보세요.

아래 SQL과 실행 계획에 대한 설명으로 가장 적절한 것을 고르시오.

[테이블 구조]

CREATE TABLE PRODUCT_SALES (
  SALE_ID NUMBER PRIMARY KEY,
  PRODUCT_CATEGORY VARCHAR2(50),
  PRODUCT_NAME VARCHAR2(100),
  SALE_DATE DATE,
  QUANTITY NUMBER
);

CREATE INDEX IDX_PS_CAT_NAME ON PRODUCT_SALES (PRODUCT_CATEGORY, PRODUCT_NAME);
CREATE INDEX IDX_PS_SALE_DATE ON PRODUCT_SALES (SALE_DATE);

[SQL 쿼리]

SELECT * FROM PRODUCT_SALES
WHERE PRODUCT_CATEGORY = 'Electronics'
  AND SALE_DATE BETWEEN '2023-01-01' AND '2023-01-31';

[옵티마이저 실행 계획 예시 (Oracle)]

-------------------------------------------------------------------------------------------------
| Id  | Operation                     | Name                | Rows  | Bytes | Cost (%CPU)| Time     |
-------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT              |                     |    10 |  1170 |     8   (0)| 00:00:01 |
|*  1 |  TABLE ACCESS BY INDEX ROWID  | PRODUCT_SALES       |    10 |  1170 |     8   (0)| 00:00:01 |
|*  2 |   INDEX RANGE SCAN            | IDX_PS_CAT_NAME     |    10 |       |     3   (0)| 00:00:01 |
-------------------------------------------------------------------------------------------------