Archives of the TeradataForum
Message Posted: Sat, 13 Dec 2003 @ 12:29:58 GMT
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)?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|