Hints FIRST_ROWS and order by not working together
Hi,
We are facing an issue like we are using hint FIRST_ROWS with a query which have a order by clause, if we are giving both together
it is not working and if we remove either order by or hint it is working
SELECT /*+FIRST_ROWS*/ * FROM (SELECT MYROWS.*,
ROWNUM RN FROM (SELECT * FROM V_REPORT WHERE START_DATE > '22-SEP-04'
AND END_DATE < '22-SEP-08' AND
(GEO_ID in (select GEO_ID from loc where anc = 0))
ORDER BY
ENTITY,OPERATION,NAME
)
MYROWS)
A simliar query from other view is working fine.
Please help me on the same.