Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 05 Apr 2010 @ 08:12:10 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Performance Tunning and Explain
From:   s.khurana

Also would like to add :

Diagnostic helpstats on for session is over generous and gives all possible combinations of stats which can be collected

Single column stats recommended can be collected but you need to give a second thought and testing before collecting Multi column stats recommended by this comman.

Also I have seen scenarios (for Tables involved in subquery in a big query) ..In which this command does not recommend any stats - even single column.

Best way is to go through Explain and look for steps in which Retreival from a single Table is there with low or no confidence.

Joins,aggregations,sorting etc may have low no confidence in the explains even you have collected stats .


Sachin Khurana

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023