Collecting Stats on PDCRDATA tables | Stats Manager Analyze Job

Database
Teradata Employee

Collecting Stats on PDCRDATA tables | Stats Manager Analyze Job

I have seen and read somewhere that it is recommended to collect stats on dbc tables. Is it recommended to collect stats on PDCRDATA tables too ?

I created and ran an Analyze job via Stats Manager and i ran it on PDCRDATA tables rather than DBC for last 3 weeks of data. I have observed Analyze job to ran for too long. Uptill now no stats have ever been collected on PDCRDATA tables. Is collecting stats for PDCRDATA tables going to make any difference in terms of optimizing the performance of Analyze Job ?

2 REPLIES
Junior Contributor

Re: Collecting Stats on PDCRDATA tables | Stats Manager Analyze Job

The dip script for PDCR located in /opt/teradata/tdat/tdbms/{your version}/etc/dippcdr.bteq includes Collect Stats for each table.

What's your TD release and how was PDCR installed?

Teradata Employee

Re: Collecting Stats on PDCRDATA tables | Stats Manager Analyze Job

Thanks dnoeth,

 

Our TD version is 15.10. I am not aware of how it was installed on our system.

We have a manually developed automated stats re-collection process on our system and PDCRDATA is not part of it.

Should we make PDCRDATA part of that process too, i mean is it required to collect/re-collect stats on PDCRDATA tables.

 

Lastly, if we eventually do collect stats on PDCRDATA, will it help in optimizing the Analyze jobs of StatsManager.