Re: count(*) for sample blcok

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,
> Prateek

Try:

SELECT COUNT(*)
FROM far_employee
SAMPLE(1); It should work better.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org