Archives of the TeradataForum

Message Posted: Wed, 05 Nov 2003 @ 13:54:11 GMT

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

Clay

I agree with you, it's a bug. I know some will argue the value of UPI with nulls (and they have a point).

It's seems if there is a null at all in the index, the stats are mis-leading. I tried a variation of your example, where only 1 column was null:

Insert into d2pts.Null_Check Values (1,1,null);
Insert into d2pts.Null_Check Values (1,2,null);
Insert into d2pts.Null_Check Values (1,3,null);
Insert into d2pts.Null_Check Values (1,4,null);
Insert into d2pts.Null_Check Values (1,5,null);

Collect Stats on d2pts.Null_Check Index (ColA, ColB, ColC);

Help stats d2pts.Null_Check;

Date      Time      Unique Values   Column Names
03/11/05  08:45:30              1   ColA,ColB,ColC

Ruth Fenwick
Database Services

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