Archives of the TeradataForum

Message Posted: Sat, 13 Dec 2003 @ 12:29:58 GMT

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

John,

Thank you for the details so far. My understanding was that index stats should somehow be reflecting the physical implementation of the index, which may vary depending on the options used with index creation. I am referring here to things like ORDERED BY VALUES or ORDERED BY HASH etc. Or, is the optimizer guided only by the column stats plus some hard coded rules which would tell it to, say, use the 'ORDERED BY VALUES' index and ignore the 'ORDERED BY HASH' one, no matter what the current situation with the index itself is (like in the index validation procedure)?

Regards,

Victor

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