Archives of the TeradataForum
Message Posted: Thu, 08 Jul 2004 @ 16:49:08 GMT
| 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.