Archives of the TeradataForum
Message Posted: Wed, 18 Dec 2003 @ 01:53:11 GMT
Single column statistics go in DBC.TVFields regardless of whether the column has an index or not. Multiple column statistics go in DBC.Indexes even if there is no index on the columns. (We define a dummy index if there is none but don't build a secondary index subtable.) I am aware of no redundancty, but it would be an interesting thing to check into.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|