 |
 |
Archives of the TeradataForum
Message Posted: Wed, 12 May 2004 @ 20:31:42 GMT
| Subj: | | Re: Feedback on Global Temporary Tables |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Wednesday, May 12, 2004 16:05 -->
| | 5. From what I've read it looks as though you can collect stats on them, but I haven't had any success doing that. I get an error message
5343 saying I can't collect stats on a materialized global temp table, but stats collected on an empty table are useless at best and misleading to
the optimizer at worst. | |
This works on V2R4.1 and V2R5.0:
COLLECT STATISTICS ON TEMPORARY SomeDB.SomeGTT COLUMN Foo;
| |
