Consider the following.
I create an employee_table and then create and execute individual collect stats commands as follows
I see there is a question posted in that feed :
Will existing table level collect stats statements utilize multiple stats in one scan when possible?
Carrie Answered :
1. First, you have to re-issue statistics collections individually when you get on 14.0 using the grouped (multiple collections in one statement) format. Only statistics that share the same USING options can be grouped. After collecting statistics using this new syntax, then you can recollect at the table level and where possible, multiple stats will be collected in a single scan.
FROM ME AGAIN :-)
From this I deduce that I do not have to re-issue the multiple collect statistics in one command if the USING options are the same for a table. Teradata will automatically do this for me. Anyone agree ?
The reason for me asking is that we use ERWIN to generate our collect stats commands and currently erwin does not support the new td14 method of collecting stats but if teradata is going to group the collect stats together then essentially it does not matter.