Archives of the TeradataForum
Message Posted: Fri, 04 Apr 2008 @ 10:48:24 GMT
Are there any other columns where the stats are absent? You can execute a "diagnostic helpstats on for session" and then execute an explain plan.
See if there are any stats recommended at the end of the statement. This command as per my experience gives all combinations of stats that can be collected( If you are joining columns A and B of a table, it will tell you to collect on A, B and (AB)) But later while implementation don't collect all the recommended ones.
Also please check if you are getting any no confidence anywhere in the explain plan before.
We can blame the optimizer only after we contend optimizer with all stats :-)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|