On 1/13/05 9:50 AM, "Greg Stark" <[EMAIL PROTECTED]> wrote:

> I think the Oracle syntax looks like
> 
>   SELECT * FROM foo SAMPLE (0.1)
> 
> I don't think I would have picked this syntax but it seems like a better idea
> to copy the existing practice rather than invent a new one.

Of course, in Oracle 'count(*)' is instantaneous.  It doesn't have to count
the physical records one by one.

Wes



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to