Specifying copyStats at the job level allows for copying statistics in bulk instead of individually at the object level. When enabled, all tables and indexes (hash or join) in the job inherit the statistics at the job level. If a different value is specified at the table or index (hash or join) level, the job-level value is overridden.
- In the job definition, set copyStats to true as in the following example:
<dmCreate> ... <copyStats>true</copyStats> <database selection="unselected"> <name>database1</name> <table selection="included"> <name>test</name> <validate_row_count>all</validate_row_count> </table> </database> ... </dmCreate>