Archives of the TeradataForum

Message Posted: Thu, 25 Sep 2014 @ 22:42:06 GMT

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

Of course the EXPLAIN varies by the table counts. An extreme example is the difference between an empty table and one that has data in it. They vary also because the optimizer might consider a table a "small" table in one situation and a large table in another. Why do you think there are statistics, and what do you think they contain? I suggest a basic class in the way the optimizer works would be of assistance.

iv

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