Re: Help with Random Samples!

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Fri, 16 Feb 2001 18:59:12 GMT
Message-ID: <3a8d7806.66116765@news.alt.net>

On Fri, 16 Feb 2001 18:09:23 GMT, sw_at_weinerfamily.org wrote:

>So I guess I can create a loop that randomly picks ids and inserts into another
>table. Each time I will have to make sure the id isn't already in the table.
No you won't. It can be primary keyed (or just uniquely indexed) and ignore insert errors. Or count exceptions to know how many failed.

>Given the possible size of the sample does an index on this temp table make sense
>or will the insert cost be too high?

Of that, I have no idea. Maybe someone else can answer that.

Brian. Received on Fri Feb 16 2001 - 12:59:12 CST