Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Select random rows?

Re: Select random rows?

From: <jobrien99_at_my-deja.com>
Date: Tue, 09 Nov 1999 19:42:27 GMT
Message-ID: <809tei$cmc$1@nnrp1.deja.com>


In article <809ehr$4js$4_at_news.seed.net.tw>,   "fumi" <fumi_at_tpts5.seed.net.tw> wrote:
>
> <jobrien99_at_my-deja.com> wrote in message
news:8054re$ufp$1_at_nnrp1.deja.com...
> stion.
> [snip]
> > Overestimate and use a cursor that fetches 10 times and then
closes.
> > So what if 2% brings back 14 rows, ignore the extra 4.
> >
> > Regards,
> > John
>
> You still didn't get the point.

  1. It's easy to guarantee I get a larger sample.
  2. Yep and Yep, but I'm trying to get a job done.

> You still didn't get the point.

Keep it up sunshine !

> 1. Though you think 2% will return 14 rows,
> you can not anticipate how many exactly rows Oracle will return,
> Oracle may returns only, say, 5 rows, for example.
> 2. If you increase the percent, though yon can get more then 10 rows
and
> ignore the extra rows, but,
> you take sample from the forward rows, not from the WHOLE table.
> The "last rows" will never be read.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 09 1999 - 13:42:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US