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

  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 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
and I think it will answer most fo the questions. Also some of Carrie's blog  like

Raja K Thaw
My wiki:
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?


You must sign in to leave a comment.