下面这个SQL执行时间需要28.4分钟:
SELECT *
FROM (SELECT ROWNUM LINE, M.*
FROM (SELECT TO_CHAR(A.OID) OID,
A.REGION,
TO_CHAR(A.GROUPOID) GROUPOID,
A.MEMTYPE,
(SELECT DICTNAME
FROM DICT_ITEM
WHERE GROUPID = 'GroupMemberType'
AND DICTID = A.MEMTYPE
) MEMTYPENAME,
A.APPLYOPERID,
SUBS.SUBSNAME SUBSNAME
FROM SUBSCRIBER SUBS, GROUP_SUBS_MEMBER A
WHERE SUBS.REGION(+) = 14
AND SUBS.ACTIVE(+) = 1
AND SUBS.SUBSID(+) = A.SUBSID
AND A.REGION = 14