where rownum < N is slow
AlleTFeb 15 2010 — edited Feb 17 2010Hi all,
I am on a 10.2.0.4 SE RAC db.
When I execute
select * from <table> where rownum < N
The query hangs as if the dbms had to perform an entire scan of the table.
Do you have any idea of why this happens???
Thanks in advance