All Forums Database
atalukder 16 posts Joined 01/12
16 Oct 2014
Looking for SQL to recreate existing statistics in teradata 14

Hi,
 
I had a SQL to recreate statistics already exist in the system I used to use during teradata  upgrade to recollect stats after upgrade.
Prior to TD 14 statistics were stored in DBC.TVFIELDS and DBC.INDEXES. Starting with TD 14 statistics information is now stored in DBC.STATSTBL. Therefore, this SQL does not work anymore. If anybody develop any   SQL   to recollect statistics in teradata 14 this will be very helpful  if you share.
My upgrade is in coming weekend on 18, October, I do not have enough time to create this SQL and test.  I will appreciate if  anybody shrare this SQL..
 
Regards,
Akleema Talukder
 
 
 

dnoeth 4628 posts Joined 11/04
16 Oct 2014

Hi Akleema,
check my New StatsInfo query for TD14

Dieter

atalukder 16 posts Joined 01/12
17 Oct 2014

Thank you very much. Very good info.  But non of the attacments I could open.  Will you please send me these files in my email
akleema_talukder@bcbstx.com.
I will really appreciate this.
 
Thanks,
Akleema

atalukder 16 posts Joined 01/12
17 Oct 2014

Hi Dieter,
 
Please  ignore my previous email. I could download the script and working on it. Thanks a lot!!!!
 
Akleema

You must sign in to leave a comment.