Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 13 Mar 2008 @ 16:44:10 GMT


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


Subj:   Re: Retreive the records with minimal spool space
 
From:   Michael Larkins

veda:

What is the select from the view look like? As mentioned previously, if it is a join it is going to take longer than if it is a single table view.

The other thing to realize is that QUALIFY = 1000 only returns the row(s) with a rank value of 1000, not 1000 rows. You probably want <= if you are looking for 1000 rows being values 1 through 1000 and not just the value of 1000. This makes me wonder about your comment of it running for 2 hrs vs 10 minutes.

Also, if you are looking to use less spool, do you really need all columns (*)?


Regards,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor



     
  <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: 27 Dec 2016