Archives of the TeradataForum

Message Posted: Fri, 26 Mar 2004 @ 18:14:07 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi John:

I see your difficulty. SAMPLE assumes that you will want only a portion of the rows. Otherwise, it is much faster to select all the rows than to sample all of the rows.

As a work around, you could have two samples coded (SAMPLE .xx, .yy). When you only want one sample the second value for substitution would always be zero. However, when you want all rows, you could pass it .50,.50 or any combination that equates to 100%.

You did not mention the substitution technique you are using, but maybe there is a way to comment out the SAMPLE when you want 100%. As mentioned above, this would complete faster than taking a SAMPLE of all the rows.

Hope this provides ideas to help you out.

Michael Larkins
Certified Teradata Master

	<Prev	Next>		<<First	<Prev	Next>	Last>>