Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 26 Mar 2004 @ 19:46:23 GMT

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

Subj:   Re: SAMPLE syntax
From:   Victor Sokovin

  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.  

It looks like the documentation might be more specific about this. I just looked up SQL Ref vol. 6 for R5.0 (the latest one I have right now):

"fraction_description: any set of unsigned floating point constant numbers in the closed interval (0,1) that specifies the percentage of rows to be sampled for a true search condition."

I understand "close interval" as though both 0.00 and 1.00 should be included in the "fraction description" but 1.00 seems to fail.


  <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: 23 Jun 2019