Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: SAMPLE syntax
From:   Michael Larkins

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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016