 |
 |
Archives of the TeradataForum
Message Posted: Sun, 12 Jun 2004 @ 22:30:36 GMT
| Subj: | | Re: Performance Improvement on this Query without Collecting Statistics |
| |
| From: | | Victor Sokovin |
| | Do you run that query on a 20-AMP system? This results in 851 rows in Date table according to statistics, but in your first post you
claimed "882 rows in DATE table". So you added one more month without updating statistics ;-) | |
| | This is no problem in this query, but might lead to incorrect spool sizes if you access using a "where date_col between ... and ...". As
the table is small you should always have uptodate stats on it. | |
There might be something else going on that the OP did not have a chance to describe for us. Alias "i" and AI_OLAP.FA_BCWK_IMP were not
in the original query so perhaps some interesting views can be involved here as well?
Victor
| |
