set SERVEROUTPUT ON 
declare
  is_exists pls_integer;
begin


select count(*) 
into is_exists
from all_tables where table_name = 'TEST__CODE_DATA';
if is_exists != 0 then
  execute immediate 'drop table TEST__CODE_DATA';

  execute immediate 'create table TEST__CODE_DATA(
    ID integer, -- PK
    CODE varchar(7),
    INDICATOR varchar(5)
  )';  
  
  execute immediate 'create index IDX_TEST__VALUE_CODE on TEST__CODE_DATA (CODE)';
  execute immediate 'create index IDX_TEST__VALUE_INDICATOR on TEST__CODE_DATA (INDICATOR)';
end if; 

-- на самом деле строк 4 с лишним миллиона
insert into TEST__CODE_DATA (ID, CODE, INDICATOR) VALUES (1, '023874', 'J');
insert into TEST__CODE_DATA (ID, CODE, INDICATOR) VALUES (2, '234444', NULL);
insert into TEST__CODE_DATA (ID, CODE, INDICATOR) VALUES (3, '332443', NULL);
insert into TEST__CODE_DATA (ID, CODE, INDICATOR) VALUES (4, '234342', 'N');
insert into TEST__CODE_DATA (ID, CODE, INDICATOR) VALUES (5, '234233', 'N');
insert into TEST__CODE_DATA (ID, CODE, INDICATOR) VALUES (6, '234444', NULL);
insert into TEST__CODE_DATA (ID, CODE, INDICATOR) VALUES (7, '200044', NULL);
insert into TEST__CODE_DATA (ID, CODE, INDICATOR) VALUES (8, '298774', NULL);
insert into TEST__CODE_DATA (ID, CODE, INDICATOR) VALUES (9, '298333', 'J');
insert into TEST__CODE_DATA (ID, CODE, INDICATOR) VALUES (10, '334443', 'J');
commit;


end;
/

select * from TEST__CODE_DATA
where INDICATOR = 'J';