Re: count(*) for sample blcok

On Dec 8, 11:44 am, DA Morgan <damor..._at_psoug.org> wrote:
> prateek wrote:
> > Hi,
> > I am curious to know why this query:
>
> > "select count(*) from far_employee sample block (1);"
>
> > returns zero at times and some other times returns a non zero number.
> > Table: far_employee is populated with more than 400K records.
>
> > Thanks,
> > PrateekTry:
>
> SELECT COUNT(*)
> FROM far_employee
> SAMPLE(1);
>
> It should work better.
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

Prateek, Please do not post the same question on both comp.databases.oracle.server and .misc. One forum is all you need to post to.

HTH -- Mark D Powell -- Received on Sat Dec 09 2006 - 17:42:18 CST