This brings back the first 10 rows only, but as for the hint (/*+ FIRST_ROWS(10) */), hehe!

select /*+ FIRST_ROWS(10) */ emp.*
from emp
where rownum <= 10
/


-----Original Message-----
From: ed
[mailto:oracledba-ezmlmshield-x62362700.[Email address protected]
Sent: Wednesday, August 31, 2005 9:45 AM
To: LazyDBA Discussion
Subject: first_rows(10)


I try to set hint /*+ FIRST_ROWS(10) */ for only first 10 records from result sets, but oracle bring me always all records;
does I need to set something on session or database for use of this hint?


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html



Oracle LazyDBA home page