 |
 |
Archives of the TeradataForum
Message Posted: Wed, 07 Aug 2003 @ 04:19:39 GMT
| Subj: | | Re: Collect stats on DBC. |
| |
| From: | | Hough, David A |
FYI. We found out the hard way that collecting stats on dbc.tvm and dbc.indexes causes problems for (of all things) ARCMAIN. If you are
dump by table it works, but if you dump by database you'll get a 3610 because the optimizer generates a bad nested join. The problem has
been around for a while (DR61104) and is supposed to be fixed in V2R5 (don't know what level). If you drop the statistics on those two
tables the 3610 goes away.
/dave
| |
