Archives of the TeradataForum
Message Posted: Tue, 19 Feb 2008 @ 14:02:24 GMT
What about statistics for the joining table.
I have seen this where a query will run for hours in a product join and use 100% of the cpu on the nodes.
You cancel it, collect statistics on the tables, and the query runs in minutes.
Just a thought.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|