Hi All,
I am running following SQL, which it taking almost 4-5 seconds and returning only 18 records.
SELECT
SUM(TOTAL_AMOUNT) C1,
a.LEVEL2_ENAME AS c2,
c.CURR_YEARMO AS c3
FROM TERRITORY_PRESET_MSNP a,
CV_RESTATED_MSNP b
LEFT OUTER JOIN
MONTH_D c
ON b.YEARMO = c.CURR_YEARMO,
PRODUCT_OFFERING d
WHERE ( b.PO_ID = d.ROW_ID
AND b.DATASOURCE_ID = 10
AND b.YEARMO = 201704
AND b.OWNER_TERR_ID = a.TERR_ID
AND c.CURR_YEARMO = 201704
AND a.YEARMO = 201706
GROUP BY c.CURR_YEARMO, a.LEVEL2_ENAME
ORDER BY C3, C2;
If I remove the ORDER BY clause it is returning results in 1 second.
Can you guide me what is the issue?
~Shalini