Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 21 Jul 2000 @ 16:57:42 GMT


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


Subj:   Re: Saturation
 
From:   Sam Sterling

Like Rolf says, saturation is a fact of life. Poor performance may not be. It depends a lot on the queries, the data model, and the indices selected. You might have a Teradata specialist (either from NCR or a good consultant) take a look at those kind of things. I recently took the average query time in an application from around 20 minutes to around 4.5 minutes and many of the queries from 12 minutes to less than 6 seconds - just by changing some indices to ones that were used by the bulk of the queries run.

Good luck.

Sam Sterling
www.ssterling.com



Admin Comment: When last tried, the URL in this Post no longer functioned.



     
  <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