Jonathan Lewis wrote:
> By giving rownum the alias rn, you've forced
> Oracle to instantiate the view. ROWNUM is
> evaluated before the "order by" is applied - that's
> the rule with ROWNUM, and you can't work
> around it. So Oracle has to acquire all the rows
> before "sorting" - so it can't push the predicate
> inside the order by, even though it manages
> to recognise that the sort is redundant.
That's right! Thanks a lot. I knew I had to do something wrong.
--
Michal Kuratczyk
Received on Fri Aug 11 2006 - 06:15:53 CDT
