Archives of the TeradataForum

Message Posted: Thu, 10 Mar 2005 @ 11:53:52 GMT

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

Thanks for the confirmation. I have come across similar strange things and my working conjecture was that statistics were collected differently (via different parts of the NCR code at least) when SI were present. In other DB that would not be a major discovery as indexes can be quite "independent" of the base tables and one can, for example, analyze them, collect stats on them, etc. However, even NCR staff would tell that in TD the new multi-column stats and the old syntax for index stats would be doing the same thing. I think your example shows once again that it is not the case. Somehow we can produce differences in the explains. Perhaps just different parts of the code are activated on different occasions, and they happen to have different bugs?

Regards,

Victor

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