Use partition name to make it faster

SELECT GL_CODE, SUM(NET_LCY) FROM ( SELECT GL_CODE, NET_LCY FROM "KTC"."SHARED_RAW_RE_GL78" PARTITION (MONTHID_08) WHERE CUST_DIVISION = 'KHCN' ) a GROUP BY GL_CODE;