On 1/13/05 9:50 AM, "Greg Stark" <gsstark@xxxxxxx> 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 majordomo@xxxxxxxxxxxxxx)