Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Count of Distinct Rows
 
From:   Ruth Fenwick

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023