 |
 |
Archives of the TeradataForum
Message Posted: Thu, 08 Dec 2005 @ 16:25:29 GMT
| Subj: | | Re: Drop Stats before loading data ? |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Thursday, December 08, 2005 11:23 -->
| | I would like to know whether stats must be dropped before loading data using mload or fastload . | |
It is not mandatory to drop stats, however, if after loading the data, the table has been extensively added to (>10% of rows added), the
optimiser would generate poor access and join plans based on the old / out of data stats. Therefore, statistics should be refreshed (or dropped)
in this case.
| |
