Re: FIRST_ROWS hint problem

i dont know the answer to you question.

But one thing for you to know is

The optimizer ignores FIRST_ROWS hint in DELETE and UPDATE statement blocks. So there is no use in adding the hint .

Also in SELECT statement blocks that contain any of the following syntax:

? Set operators (UNION, INTERSECT, MINUS, UNION ALL)

? GROUP BY clause

? FOR UPDATE clause

? Aggregate functions

? DISTINCT operator

? ORDER BY clauses, when there is no index on the ordering columns

These statements cannot be optimized for best response time, because Oracle must retrieve all rows accessed by the statement before returning the first row.

-- 
Message posted via http://www.oraclemonster.com