Query is 

```
SELECT DISTINCT A.X1, A.X2, A.X3, TO_DATE(A.EVNT_SCHED_DATE,'DD-Mon-YYYY') AS EVNT_SCHED_DATE,
               A.X4, A.MOVEMENT_TYPE, TRIM(A.EFFECTIVE_STATUS) AS STATUS, A.STATUS_TIME, A.TYPE, 
               A.LEG_NUMBER,
               CASE WHEN A.EFFECTIVE_STATUS='BT' THEN 'NLT'
                    WHEN A.EFFECTIVE_STATUS='NLT' THEN 'NLT'
                    WHEN A.EFFECTIVE_STATUS='MKUP' THEN 'MKUP'
               END  AS STATUS
FROM PHASE1.DY_STATUS_ZONE A
WHERE A.LAST_LEG_FLAG='Y'
                   AND SCHLD_DATE>='01-Apr-2019'--TO_DATE(''||MNTH_DATE||'','DD-Mon-YYYY') 
                AND SCHLD_DATE<='20-Feb-2020'--TO_DATE(''||TILL_DATE||'','DD-Mon-YYYY') 
                AND A.MOVEMENT_TYPE  IN ('P')
                AND (EXCEPTIONAL_FLAG='N' OR EXCEPTION_TYPE='5') ---------SS

```

PHASE1.DY\_STATUS\_ZONE has 710246 records in it , Please guide if this query can be optimized ?