Archives of the TeradataForum
Message Posted: Wed, 07 Feb 2001 @ 17:30:24 GMT
To Dave's last point - Performance tuning analysis is the best way to determine whether statistics collection is needed. In some cases, queries using columns with no statistics can run the same or better as when there are statistics on those columns. My recommendation is first, collect on the Primary Index and any secondaries. Then second, just collect on columns in your WHERE clause that are weakly selective (columns with small domains). Then EXPLAIN some queries, and collect stats/add secondaries, etc. to "fix" the queries. By doing it this way, you won't collect on unnecessary columns, and you won't collect on columns that actually adversely affect the join paths.
Your mileage may very :-)
Just my two cents
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|