  |  
  |  
 
Archives of the TeradataForum 
 
 
Message Posted: Wed, 10 Jan 2001 @ 20:09:48 GMT 
 
  
 
 
 
 
  
|  Subj:  |   |  Re: Limited Select  |   
|     |   
|  From:  |   |  John Hall  |   
  
 
 
  
As far as I know, the SAMPLE method still requires the Teradata to do the same amount of work internally (give or take a bit) as if all
the rows were being returned.  It only affects the number of rows that are being returned to the user from the answer spool.  Actually, an
EXPLAIN would give you a more definitive answer (I don't have access to a machine at the moment, so I can't check it for you). 
 
 
 
 
   
 
 |   |