Archives of the TeradataForum
Message Posted: Fri, 26 Mar 2004 @ 18:14:07 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|