Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 21 Feb 2002 @ 20:08:08 GMT


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


Subj:   Re: BTEQ Question
 
From:   Eric J. Kohut

Retcancel only tell the query to throw away the remaining rows at the PE after the first 100 rows.

If you want it speed up the query, you need to use sample 100 in your query.

It still will run a little longer than you might think but should be much faster than your approach. Assumes V2 R3.


Thanks,

Eric

EJK
Eric J. Kohut
Senior Solutions Consultant - Teradata Solutions Group - Retail
Certified Teradata Master
NCR Corp.



     
  <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: 15 Jun 2023