Archives of the TeradataForum

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


	<Prev	Next>		<<First	<Prev	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?

Thanks,

Zdravko Sonje