Archives of the TeradataForum
Message Posted: Fri, 11 Feb 2005 @ 17:28:12 GMT
Craig Ferry wrote:
Are you shure about statistics? There's a lot of low or no confidence...
If you run a current patch level in V2R5+ submit a
"diagnostic helpstats on for session;"
to find out about missing stats.
If you explain a query it adds a new section to the end of explain text:
BEGIN RECOMMENDED STATS -> ... <- END RECOMMENDED STATS
But don't worry too much about it, the optimizer usually recommends stats on almost every column used (and always tells about (HighConf) as resulting confidence level, even if it's not true)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|