Archives of the TeradataForum
Message Posted: Thu, 24 Jun 2004 @ 17:06:15 GMT
We have tried this approach in the past with no luck. It seems as if 9 times out of 10, the optimiser decides to perform a redistribution of the small table back to how it would have been before placing it onto a single AMP.
Never tried this one. We have always ensured the statistics are as accurate as possible. I will certainly try this approach.
Has been since our system went live.
It would however be far simpler and more of a direct prompt to the optimiser, if a feature exists to set a table as duplicated.
Thanks Claybourne, your comments are most welcome.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|