 |
 |
Archives of the TeradataForum
Message Posted: Tue, 08 Oct 2013 @ 19:34:08 GMT
| Subj: | | Re: Expalin under estimating the stats calculation in 13.10 version |
| |
| From: | | Panchal, Hemanshu |
Anomy.Anom wrote:
| | Seems likely that in 13.10 you need to collect additional stats on the tables used in the subquery, so the optimizer can make a better
estimate. | |
Yeh I did the same but that does not change the optimizer plan and query proceeds to be in product join condition
Any alternative solution
Thanks
Hemanshu Panchal
TDCOE Team
Morgan Stanley
| |
