Archives of the TeradataForum
Message Posted: Mon, 18 Jun 2001 @ 15:03:46 GMT
Basically, the feedback I've received on collecting statistics was to do so for all indexes, with the possible exception of UPI's on very large tables.
My additional point here is that, yes, you definitely should collect statistics on the primary indexes of small tables regardless of index type (UPI or NUPI). This lets the optimizer know that the table is, in fact, a small table.
David W. Roth
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|