Bases de Datos - Optimizar una consulta ORACLE

select *

from hcice

where f_cod_Cent=10

and f_num_cice=1

and f_fec_ini=to_date('06032020','ddmmyyyy');

CREATE TABLE SIGO.HCICE

(

  F_COD_CENT    NUMBER(5)                       NOT NULL,

  F_NUM_CICE    NUMBER(3)                       NOT NULL,

  F_FEC_INI     DATE                            NOT NULL,

  F_HH_INI      VARCHAR2(4 BYTE)                NOT NULL,

  F_FEC_FIN     DATE                            NOT NULL,

  F_HH_FIN      VARCHAR2(4 BYTE),

  F_COST_INCRE  FLOAT(126)                      DEFAULT 0                     NOT NULL,

  F_COD_USU     VARCHAR2(8 BYTE),

  F_FECACT      DATE                            NOT NULL,

  F_PRIORIDAD   NUMBER(5)                       NOT NULL,

  F_COD_CEOP    NUMBER(3),

  F_CORR_PART   NUMBER(3),

  F_PARTICION   NUMBER(10)

)

TABLESPACE ENDESA

PCTUSED    0

PCTFREE    10

INITRANS   1

MAXTRANS   255

STORAGE    (

            INITIAL          64K

            MINEXTENTS       1

            MAXEXTENTS       UNLIMITED

            PCTINCREASE      0

            BUFFER_POOL      DEFAULT

           )

NOLOGGING

NOCOMPRESS

NOCACHE

NOPARALLEL

MONITORING;

CREATE UNIQUE INDEX SIGO.COINCE_VER_PK ON SIGO.HCICE

(F_COD_CENT, F_NUM_CICE, F_FEC_INI, F_HH_INI)

LOGGING

TABLESPACE ENDESA

PCTFREE    10

INITRANS   2

MAXTRANS   255

STORAGE    (

            INITIAL          64K

            MINEXTENTS       1

            MAXEXTENTS       UNLIMITED

            PCTINCREASE      0

            BUFFER_POOL      DEFAULT

           )

NOPARALLEL;

ALTER TABLE SIGO.HCICE ADD (

  CONSTRAINT COINCE_VER_PK

  PRIMARY KEY

  (F_COD_CENT, F_NUM_CICE, F_FEC_INI, F_HH_INI)

  USING INDEX SIGO.COINCE_VER_PK

  ENABLE VALIDATE);

ALTER TABLE SIGO.HCICE ADD (

  CONSTRAINT CINCE_CICE_VER_FK

  FOREIGN KEY (F_COD_CENT, F_NUM_CICE)

  REFERENCES SIGO.GCICE (F_COD_CENT,F_NUM_CICE)

  ENABLE NOVALIDATE);