Add sde.st_EnvIntersect to the where filter: SELECT /*+ USE_NL(Z9_COORD SEC_POLY) */ Z9_COORD.ZIP5,Z9_COORD.ZIP4,'V' FROM SUBMIT_MST_ZIP9_COORD Z9_COORD,wadown.SUBMIT_WAP_SECTION_POLYGON SEC_POLY WHERE SDE.ST_EnvINTERSECTS(Z9_COORD.SHAPE,SEC_POLY.SHAPE) = 1 AND SDE.ST_INTERSECTS(Z9_COORD.SHAPE,SEC_POLY.SHAPE) = 1 AND z9_COORD.FACILITY_NBR = 191 AND SEC_POLY.FACILITY_NBR = 191 AND SEC_POLY.WORK_AREA_PLAN_ID = 265538 AND Z9_COORD.data_vendor_type = 'NTQ' AND Z9_COORD.GEOCODE_SCORE IN (0, 1, 2, 3, 5);