Archives of the TeradataForum
Message Posted: Thu, 08 Dec 2005 @ 21:22:03 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|