 |
 |
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
| |
