Looking for SQL to recreate existing statistics in teradata 14

Database
Enthusiast

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

 

3 REPLIES
Junior Contributor

Re: Looking for SQL to recreate existing statistics in teradata 14

Hi Akleema,

check my New StatsInfo query for TD14

Enthusiast

Re: Looking for SQL to recreate existing statistics in teradata 14

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

Enthusiast

Re: Looking for SQL to recreate existing statistics in teradata 14

Hi Dieter,

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

Akleema