Re: Randomly pick

Niall Litchfield wrote:
>
> would this not give the same results each time? I can't see this doing
> anything other than a full table scan and then filtering. i.e. Oracle would
> use the same access path each time?
> curious
>
> >
> > A simple, altho' not scientifically random in the true sense, is to do a
> > non-ordered no index select like:
> >
> > Select * from big_table where rownum < 100001;

Yes, it will bring the result-set in the same order each time. The order is given by the physical appearance in the tablespace... which will not change very often...

Regards, Stephan Received on Thu Jan 11 2001 - 10:34:03 CST