View takes too long to retrieve data, since upgrade from 10g to 11g
Hi All,
since we've updated to 11g I have one specific view, which takes too long, due to many sorts and hash joins. It's not that much data, which is retrieved, but actually it's too time consuming.
I already identified the line of code, at least I think it's this line at the end of the view. This problem causes the temp tablespace to be filled and then the query gets crashed.
) BASE_VALUESLEFT JOIN DSDCAL ON DSDCAL.DCAL_CALENDAR_DATE = BASE_VALUES.EFFECT_DATELEFT JOIN XIM_V_LKP_SITES FR_SITE ON FR_SITE.DEML_STE_CD = BASE_VALUES.FROM_STE_CD0