Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 01 Dec 2004 @ 21:38:35 GMT


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


Subj:   Re: Statistics Problems
 
From:   Claybourne Barrineau

Ulrich,

I like your idea...I'm wondering why we didn't try this approach...it seems easier and cleaner than using a second table.

Regarding statistics; however, I'll still have a problem when I try and join view A_Current.ColA to another table because the optimizer has no stats on the ColA (since it is built in spool by coalescing the base table and the shadow table.)


Thanks,

Clay

Claybourne L. Barrineau
Senior Application DBA
Coca-Cola Enterprises, Inc.



     
  <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