collect stats

Database
Enthusiast

collect stats

There is an Orders table which which is a PPI table with partition on order_date column.

If we need to collect stats ,which will be better and why?

COLLECT STATISTICS ON orders COLUMN PARTITION;

COLLECT STATISTICS ON orders COLUMN order_date;

3 REPLIES
Junior Supporter

Re: collect stats

Hi:

Carrie Ballinger explains it much better than I could here:

http://developer.teradata.com/database/articles/statistics-collection-recommendations-for-teradata-1...

HTH.

Cheers.

Carlos.

Junior Contributor

Re: collect stats

There's also new version of those recommendations for TD13.10:

http://developer.teradata.com/node/10528

Dieter

Junior Supporter

Re: collect stats

Yup, Dieter.

I just saw it just a minute after I posted the hint!

Cheers.

Carlos.