Archives of the TeradataForum

Message Posted: Fri, 26 Sep 2014 @ 20:39:38 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Friday, September 26, 2014 14:39 -->

Note that two tables in TST are 100% of size in PRD, one about 50%, the remaining two more like 10%. And in PRD, ACCT is largest at nearly double CUBE_ROW; while in TST CUBE_ROW is 50% larger than ACCT. Those are huge differences in relative sizes, so one should not be at all surprised that EXPLAINs differ.

The question you really seem to be asking is "How can I make the TST EXPLAIN just like the PRD one?" At a minimum you would need to copy the stats - not just stats on same columns, but actual collected stats values.

Or maybe the question is only "How can I make TST perform well?" Since the data demographics are entirely different, you may need stats on different (combinations of) columns to get good performance.

	<Prev	Next>		<<First	<Prev	Next>	Last>>