Archives of the TeradataForum
Message Posted: Thu, 03 May 2012 @ 16:56:34 GMT
Single column index stats are stored in the same table as single column stats.
Multicolumn index stats are not, so there is a difference between stats on multiple columns and stats on a multi-column index.
This is why I always recommend using named indexes and collection on the named index. You cannot rely on column statistics to support your indexes.
David W. Roth
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|