테이블 조회 시, 조건절 컬럼에 index 존재해도 full scan으로 수행되는 현상

DROP INDEX TIBERO.TB_STOR_IX01; CREATE INDEX "TIBERO"."TB_STOR_IX01" ON TIBERO."TB_STOR" ( "RECORD_CENTER_ID" ASC, "ORIGN_ID" ASC ) / EXEC DBMS_STATS.GATHER_TABLE_STATS('TIBERO', 'TB_STOR', estimate_percent=>3, cascade=>TRUE, degree=>8); SELECT * FROM TIBERO.TB_STOR WHERE RECORD_CENTER_ID = '0000001' AND ORIGN_ID = 'OR20210506145231470' AND VIRUS_FLAG = '1' ; Execution Plan -------------------------------------------------------------------------------- 1 TABLE ACCESS (FULL): TB_STOR (Cost:1185460, %%CPU:0, Rows:1) Predicate Information -------------------------------------------------------------------------------- 1 - filter: (""TB_STOR"".""VIRUS_FLAG"" = '1') AND (""TB_STOR"".""RECO RD_CENTER_ID"" = '0000001') AND (""TB_STOR"".""ORIGN_ID"" = 'OR20210506145231470') (0.000 * 1.000 * 1.000)0') (0.000 * 1.000 * 1.000) NAME VALUE ------------------------------ ---------- db block gets 6349 consistent gets 2782280 physical reads 2785431 redo size 0 sorts (disk) 0 sorts (memory) 3 rows processed 0