Teradata : Disadvantage of Collect stats
4
votes
1
answer
2178
views
I want to know **any disadvantage can occur by doing collect stats on a column** that is being widely used in join condition across so many procedures ? (Eg. the column is accessed 300+ times access in 60 days)
While searching in google, i came to know the only issue that can cause performance degradation is *out of date Stats *.
In this case, this is not going to happen as whenever data of table changes, we are going to run collect stats.
Any other disadvantage is there because of adding collect stats other than space consumption ?
Asked by Sinoop Joy
(51 rep)
Jul 9, 2013, 05:13 AM
Last activity: Aug 1, 2013, 11:51 AM
Last activity: Aug 1, 2013, 11:51 AM