Collect Statistics

Tools
Enthusiast

Collect Statistics

Hi Folks,

Can any one tell me ,

can we collect the statistics against GTT table ???

1 REPLY
Teradata Employee

Re: Collect Statistics

Include the keyword TEMPORARY in front of the table name to collect statistics on a materialized instance of a GTT.

If you "collect stats" on the base GTT definition (without TEMPORARY), it effectively creates a default list of indexes and columns that can be used for a "re-collect" request on each materialized instance.