Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sat, 24 Oct 2009 @ 18:45:59 GMT


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


Subj:   Re: Performance tuning, Query optimization, Spool space errors
 
From:   Singh, Lakhwant

Hi,

"Performance TUNING" is same as "Query optimization".

"Dealing spool space errors": Spool Space Error is one of the issues that need "Query optimization/Tuning" to be done. Sometimes the queries may not spool out but might be taking longer than expected to complete OR some queries might be showing higher CPU Skew. In such scenarios too we need to Optimize/Tune the Queries.

For example, if there is a query that involves JOIN of two or more tables but the columns used in JOIN are NOT UPI/PI columns. If there are no STATS collected on such columns then the query may spool out OR it may take too much of time to complete. In such a scenario we should COLLECT STATS on such columns that are used in JOIN but are not part of UPI/PI of the tables.

In another example, we might be loading a table having SECONDARY INDEXES (SI) defined on it. This might make the query run slower. In such a case, we can drop the SI on the target table and then load the data in it. After loading the table, SI can again be created on the target table using CREATE INDEX statement.


Thanks

Lakhwant



     
  <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