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..
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
I will really appreciate this.
Please ignore my previous email. I could download the script and working on it. Thanks a lot!!!!