All Forums Database
spkother 18 posts Joined 07/13
12 Sep 2014
Collect stats

Hi
 
  I have a requirement where I have to load like below,
Table A->intermediate table 1->intermediate table 2->table B
running above statements between BTET.have to collect stats after table1 loaded as well as table2 loaded.how we can achieve this.

Raja_KT 1246 posts Joined 07/09
13 Sep 2014

If you can provide more details, then it will be easy, reasons, what is there in intermediate etc.. etc... You can refer to the link
http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1184_111A/Alter_Function-Details.008.169.html
and I think it will answer most fo the questions. Also some of Carrie's blog  like
http://developer.teradata.com/blog/carrie/2012/08/new-opportunities-for-statistics-collection-in-teradata-14-0

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

dnoeth 4628 posts Joined 11/04
13 Sep 2014

COLLECT STATS is considered a DDL statement -> it can only be the final statement within a transaction.
 
So you can't collect stats after TableA was loaded.
Are you sure you need to run the load as a single transaction?

Dieter

You must sign in to leave a comment.