Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 08 Jul 2004 @ 16:49:08 GMT

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

Subj:   Re: Confidence Levels in TDQM
From:   Anantaraman, Kumaran (K.)

Ballinger, Carrie wrote

  In your example, only steps 2 and 4 will be considered. The rows for those two steps will be summed, as will the estimated times. These sums must both exceed the thresholds you set, because you AND-ed them together in the rule definition.  


Thank you for the response. Can you confirm that the row counts will be summed up over the many eligible steps? It makes sense to sum the times, but not the row counts.

------- From V2R5 manual : --------
Maximum Row Count
Specify the maximum number of rows, greater than zero, generated by ANY STEP OF A QUERY. The maximum number of rows can be either the final row count estimate or the maximum row count estimate during any step in the query.

  <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: 23 Jun 2019