Hi,
I have a query which gives results in few seconds when not using Order By. But the same query when used with Order By is not fetching result. Output of query is approx 40k records.
SELECT
(SELECT b.ANSC7_DESC
FROM RG_ANSCS b
WHERE b.name = a.name) AS REGION,
(SELECT b.ANSC6_DESC
FROM RG_ANSCS b
WHERE b.name = a.name) AS SUBREGION,
(SELECT b.ANSC4_DESC
FROM RG_ANSCS b
WHERE b.name = a.name) AS COUNTRY,
a.CTRY AS CTRY_CODE,
(SELECT b.ANSC3_DESC
FROM RG_ANSCS b
WHERE b.name = a.name) AS LC,
a.PL_CODE AS SERV,
a.NODE AS KEY
FROM RG_VW a
order by a.NAME;
Tried this as well
select * from
(
SELECT
(SELECT b.ANSC7_DESC
FROM RG_ANSCS b
WHERE b.name = a.name) AS REGION,
(SELECT b.ANSC6_DESC
FROM RG_ANSCS b
WHERE b.name = a.name) AS SUBREGION,
(SELECT b.ANSC4_DESC
FROM RG_ANSCS b
WHERE b.name = a.name) AS COUNTRY,
a.CTRY AS CTRY_CODE,
(SELECT b.ANSC3_DESC
FROM RG_ANSCS b
WHERE b.name = a.name) AS LC,
a.PL_CODE AS SERV,
a.NODE AS KEY
FROM RG_VW a )
order by KEY ...Still see same issue.
Any suggestions on this please..