Collect stats running for 4hours avg and taking spool 4tb for 400GB table

Database
Highlighted
Junior Contributor

Re: Collect stats running for 4hours avg and taking spool 4tb for 400GB table

When you do a SHOW STATS VALUES you can see the history records.

 

If this is the table's UPI you might not need to collect stats at all, the optimizer already knows that the combination is unique, check Explains if for actual confidence level.

Enthusiast

Re: Collect stats running for 4hours avg and taking spool 4tb for 400GB table

So,Can i assume for a big table like 600GB this much spool and timming to run collect stats is ok

Enthusiast

Re: Collect stats running for 4hours avg and taking spool 4tb for 400GB table

yes there's default percent 

here's the artcile on it by carrie which should  be helpful. 

https://downloads.teradata.com/blog/carrie/2014/02/statistics-threshold-functionality-101

 

is there need for stats to be collected daily on these large tables, could it be weekly.? does the data change every day by that much.. the earlier recommendation was if the data changes 10% then we need to collect stats.. 

also is the table partitioned ?.