Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 08 Dec 2005 @ 21:22:03 GMT

  <Prev Next>  
Next> Last>>  

Subj:   How sample works?
From:   Sonje, Zdravko

Can someone explain how "sample" works?

Explain for "select * from table1 sample 100" says:

     (all_amps), which is built locally on the AMPs.  The result
     spool file will not be cached in memory.  The size of Spool 3
     is estimated with low confidence to be 11,767,538 rows.  The
     estimated time for this step is 3 hours and 58 minutes.

Table table1 has 300 m records and I need only 100 records. What is the trick?


Zdravko Sonje

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020