|
Archives of the TeradataForumMessage Posted: Fri, 29 Oct 2010 @ 14:03:19 GMT
There are restrictions on stats on GT tables. Here are some rules from some info I have: Rules for using InsertStats on Global Temporary tables: You can collect most statistics on a global temporary table with the following exceptions: You cannot collect statistics on multiple columns. You cannot collect statistics on a named index by index name for a materialized global temporary table. You cannot collect PARTITION statistics. Table must be materialized in order to run collect statistics on it (at table level. So, following the above rules, apply stats on the 'un-materialized' table. Then, after the table is materialized, then you can execute the
COLLECT STATS ON The manuals are pretty clear on this;-) JK
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||