see my reply in the parallel thread on comp.databases.oracle.misc for
caveats and performance comparisons
"Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote in message
news:Q_Nsb.141800$ao4.451892_at_attbi_s51...
> go to asktom.oracle.com and search. Answer is there.
> Jim
> <ketansweta_at_sbcglobal.net> wrote in message
> news:THFsb.30024$FD7.22223_at_newssvr27.news.prodigy.com...
> > Hi! Folks
> >
> > I am sure many of you have come across this problem which I am facing
and
> > hope to have some suggestions.
> > We have an web application with tones of where clauses and group by but
> > eventually the result set could be any where
> > from 1 to 10000. Now the web page would display only 1 to 10 items after
> > which if you would click on next it would show
> > from 11 to 20 - till here it is some what do able - the problem lies
when
> > the user click on directly 45th page which should show records
> > from 2000 onwards. I was thinking of using the rownum function ..
remember
> > this is a select from a 500K table - .
> >
> > Any folks who have a better idea or suggestion would be great ful.
> >
> > Thanks
> > Ketan
> >
> >
>
>
Received on Thu Nov 13 2003 - 12:15:59 CST
