Re: Performance problem - help appreciated.

"Anurag Varma" <avdbi_at_hotmail.com> wrote in message news:<0vAac.23524$u_2.5055_at_nwrddc01.gnilink.net>...
> >
> > I tried the rownum trick and it appears to work.
> >
> > But please tell me why!!!!
> >
> > CE
>
> The inclusion of rownum in the select clause forces oracle
> to execute the inner query first. Otherwise it tends to rewrite the query.
>
> Tom Kyte gives a good explanation of this in his book .. and maybe
> he might have explained this in his website also asktom.oracle.com
> ..
> Anurag

Excellent explanation (Tom Kyte couldn't have explained it better ;-))

I do have Tom's book (I must have been looking in the wrong place - it is a big book!) and I _always_ go to askTom as my first point of call - I just couldn't find thr right article.

Anyway, thanks very much for your help.

CE Received on Thu Apr 01 2004 - 03:01:15 CST