If collect stats is not done on the table what will happen?

Teradata uses a cost based optimizer and cost estimates are done based on statistics.
So if you donot have statistics collected then optimizer will use a Dynamic AMP Sampling method to get the stats.
If your table is big and data was unevenly distributed then dynamic sampling may not get right information and yourperformance will suffer.

Post a Comment