Archives of the TeradataForum
Message Posted: Fri, 27 Jul 2012 @ 07:24:56 GMT
Kindly let me know the explanation for below scenario.
Suppose there are 2 tables, table a with 10 million records, table b has 100 million records, now we are joining both tables, when we see explain plan of PE the plan showing TD will took smaller table a and it will redistributes it among all AMPs to do join.
My question is: by doing this plan is the optimizer is correct job or not ?
So much spool space required for this operation.
If I have UPI and some SI on this table, will PE select above plan?
Kindly let me know.
Thanks in advance,
Sughesh I S.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|