Archives of the TeradataForum
Message Posted: Wed, 12 Mar 2003 @ 20:13:29 GMT
<-- Anonymously Posted: Wednesday, March 12, 2003 15:09 -->
Collecting stat on small table very helpful why?
when Teradata join one small table with very big, The optimizer copy one of the table on all Amps. By collecting statistics on small tables Teradata server now which table to copy. So Teradata pick small table.
it is not necessary you only collect statistics on small tables. you can collect statistics all indexes Primary plus secondary after every 10% data change in tables
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|